title: Oracle JOIN USING + Subquery : ora-00904 string: invalid identifier
body: <p>i m having a little syntax problem in my query (simplified) :</p>
  
  <pre><code>select *
  from table1 t1
  inner join table2 t2 using (pk1)
  inner join table3 t3 using (pk2)
  where not exists (select1 from table4 t4 where t4.pk1 = t1.pk1)
  </code></pre>
  
  <p>By using the "using" keyword, oracle doesnt allow table identifier in front of the column name (eg : t1.pk1, only pk1 can be used)</p>
  
  <p>If i write :</p>
  
  <pre><code>select *
  from table1 t1
  inner join table2 t2 using (pk1)
  inner join table3 t3 using (pk2)
  where not exists (select1 from table4 t4 where t4.pk1 = pk1)
  </code></pre>
  
  <p>This query will not give the expected results.</p>
  
  <p>But since i am using an "exists" subquery, how can i join this subquery ?</p>
  
  <p>Of course, i suppose i could write this query another way and avoid the exists, or i could NOT use "using".</p>
  
  <p>But is it possible to have "join / using" combined with a subquery in the where clause ?</p>
  
  <p>Edit : using Oracle 10gR2</p>