Join 3 tables

[Awuah]

what is the syntax for joining 3 tables on a primary key that is present in all three tables.

Thank you.

 

[MeanGreen]

This is a basic Equi-Join:

Select * from Table1
join table2
on table1.key = table2.key
join table3
on table1.key = table3.key

If you want all rows from one of the tables then you want to do an outer join.

Good Luck!

 

[Awuah]

Thank you MeanGreen. I appreciate your help. It worked.