Select Records without relation.....

[FatCat]

Hi @ll !

I've 2 tables and the relation between them is the id. I want only select the records from table A which are not present in table B!

Is there any suggestion!

Greets
FatCat

[CyberSensei]

FatCat,

This may work in mySQL:

SELECT tableA.*
FROM tableA LEFT JOIN tableB ON tableA.ID = tableB.ID
WHERE (tableB.ID Is Null);

GL