The left join works the same for two or more tables.
select * from table1
left join table2 on table1.id=table2.id
left join table3 on table1.id=table3.id
...
Just specify the table you want to join and what to use to join them.
On Tuesday, August 12, 2003, at 03:16 PM, Michael Cortes wrote:
I
Thanks. I couldn't find the correct syntax in my resources. I tried at one
point to use commas like:
select * from table1
left join table2,table3 on table1.id=table2.id,table1.id=table3.id
Thanks again for the correct syntax.
On Tuesday 12 August 2003 04:00 pm, Brent Baisley wrote:
The left
I know that we can ..
select last_name,first_name, table2.school from table1 left join table2 on
school_id=bldg_id
Listing all students and giving the school name for all students, if they have
one. If not, it lists the kid anyway and leaves that field blank.
Anyhow, how about multiple