title: Postgresql : How to join with multiple cross-reference table?
body: <p>I've seen a lot of post on multiple JOIN but it didn't help me in my case.</p>
  
  <p>Consider that I have three tables and two cross-reference tables. That's the difference with the others posts where they had multiple tables but one cross-reference table in the FROM.</p>
  
  <p>Table1 -> cross-ref1 &lt;- table2 -> cross-ref2 &lt;- table3</p>
  
  <p>My version of Postgresql is : 9.0.11, and I'm working with W7 64 bits.</p>
  
  <p>My request is the following stuff :</p>
  
  <pre><code>Select [columns] from cross-ref1, cross-ref2
  
  INNER JOIN table1 ON table1.id_table1=cross-ref1.ref_id_table1
  
  INNER JOIN table2 ON table2.id=cross-ref1.ref_id_table2
  
  INNER JOIN table2 On table2.id_table2=cross-ref2.ref_id_table2
  
  INNER JOIN table3 ON table3.id_table3=cross-ref2.ref_id_table3
  </code></pre>
  
  <p>The error message is : "Table name is specified more than once."</p>
  
  <p>Can you explain me the error ?</p>
  
  <p>Thanks</p>