title: multiple table join error, with expected
body: <p>Error:</p>
  
  <p>``with'' expected but identifier indv found: indv join com</p>
  
  <p>Code:</p>
  
  <pre><code>select temp.CAND_NAME, count(*)
  from 
  (
  indv join com
  on indv.OTHER_ID = com.CMTE_ID
  
   join can
  
  on indv.CMTE_ID = can.CAND_PCC) as temp
  
  group by temp.CAND_ID
  having temp.CAND_ID = "P00003392" or 
  temp.CAND_ID = "P60006111" or 
  temp.CAND_ID = "P60007168" or temp.CAND_ID = "P80001571"
  </code></pre>
  
  <p>What could be wrong?</p>
  
  <p>What I'm doing:</p>
  
  <p>I have three tables:</p>
  
  <p>indv, com, and can.</p>
  
  <p>I want to join all three, and query can.CAND_NAME as well as count(*)</p>
  
  <p>How do I want to join?</p>
  
  <p>2 things:</p>
  
  <ol>
  <li>indv.OTHER_ID = com._CMTE_ID</li>
  <li>indv.CMTE_ID = can.CAND_PCC</li>
  </ol>