Select from 2 tables, even when there nothing in table 2

[Sergeant]

Hi,

got two tables, IDs are matching.

table1
======
ID

table2
=======
ID
name

SELECT FROM `table1`,`table2` WHEN
table1.ID = table2.ID

But, it should also select the ids from table1 when there are no records in table 2 with the same ID, how to do that?

thanks in advance

[DaveMaxwell]

Use the LEFT JOIN syntax. If there's nothing corresponding in table2, the fields will be null.

SELECT table1.ID
, table1.Field1
, table1.Field2
, table2.Field3
, table2.Field4
FROM table1 LEFT JOIN table2 ON table1.id = table2.id

[Sergeant]

thanks, that did the trick, for some reason I still cannot grasp the join thingie in mysql.