advanced code snippet search

Posted By

Scooter on 11/10/08


Tagged

join


Versions (?)

Joining the same table on different columns

 / Published in: SQL
 

I had a situation recently where I needed to join the same table on different columns. Most web sites don't give an example of this, so I thought it a good idea to post here. The example below only shows joining twice, but you can join as many times as necessary.

Expand | Embed | Plain Text 
  1. SELECT column1, table2.COLUMN AS column2, table3.COLUMN AS column3
  2. FROM table1 
  3. JOIN otherTable AS table2 ON table1.FK1 = table2.PK
  4. JOIN otherTable AS table3 ON table1.FK2 = table3.PK
  5. WHERE table1.PK = ?

Report this snippet  

You need to login to post a comment.