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