Results 1 to 3 of 3
Dec 30, 2008, 08:41 #1
- Join Date
- Feb 2004
- 0 Post(s)
- 0 Thread(s)
Select from 2 tables, even when there nothing in table 2
got two tables, IDs are matching.
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