i have three tables table1, table2 and table3.

select * from table1, table2, table3
where table1.ID = "IDnumber"
table1.ID = table2.ID
table1.ID = table3.ID

if table3 doesnt have any rows with a matching IDnumber it wont return any results even if table1 and table2 have rows with the same IDnumber. how can i modify my query so i get a rows even if there are no rows on table3...

I'd use a LEFT JOIN if I wwanted to do that.

-PatP

i'll research that... thank you... wow fast reply... =)

We aim to please!

-PatP

select * from table2 JOIN table1 ON table1.ID = table2.ID JOIN table3 ON table1.ID= table3.ID


//This should join all three tables based on their IDs and you should be able to select anything from each table. Hope it helps

thank you guys. i got it working with the "LEFT JOIN" =)