I can't seem to figure out how to join 3 tables together and I can only find examples of joining two tables.

What I need is to join Table_1 to Table_2 to Table_3, in order to get data from Table_1 and Table_3.

How can I do this?

select table1.blah, table3.blah
FROM table1
inner join table2 on table1.column = table2.column
inner join table3 on table2.column = table3.column

preferably using pk/fk relationships for "column".


Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Scott's got it.... spot on, too, about the pk/fk relationship if at all possible.

--Jeff Moden