i was using "NOT IN" syntax to get the details from a table1 which is not in table2, but it shows nothing when the table2 is empty, can i get all the details from table1 even if the table2 is empty.
[code=mysql]
select * from table1, table2 where table1.ID NOT IN table2.ID,[/code]
[code=mysql]
select * from table1, table2 where table1.ID NOT IN table2.ID,[/code]
Comment