Select table twice in join 1

[mbowles]

I have 2 tables, and table1 has 2 fields that point to records in table2, one to many. I need to do a query to get one record back but populated with the data from 2 records in table2 and the single record in table1. Any thoughts?

 

[JamesLean]

Something like this?

SELECT cols
FROM table1 t1
  JOIN table2 t2 ON t1.fk1 = t2.pk
  JOIN table2 t3 ON t1.fk2 = t3.pk

--James

 

[mbowles]

Thanks...brain freeze kept me from use the same table twice with a different dot notation!! Worked like a charm.