title: ORACLE/SQL - Joining 3 tables that aren't all interconnected
body: <p>I need help joining 3 tables where they are not all interconnected</p>
  
  <p>So lets say I have tables A, B, C</p>
  
  <p>here are the relations</p>
  
  <p>A.type = B.type</p>
  
  <p>A.model = C.model</p>
  
  <p>What I need to do is inner join A and B and return all the matched A records.  Next I need to pull the records from C that match on the prior join.</p>
  
  <p>Or in other words all the records in C that are in A where A is in B</p>
  
  <p>Hope that makes sense.  Sorry for no data examples.</p>
  
  <p>I have tried this</p>
  
  <pre><code>select
      c.*
  from
      c, a, b
  where
      c.model_ = a.model_
      and a.type_ = b.type_
  </code></pre>
  
  <p>but receive this message 'Errors: Query has MERGE JOIN CARTESIAN. You must correct where-clause to properly join tables in the select statement.'</p>