sql: check if entry in table A exists in table B

sql exists

SELECT *FROM   BWHERE  NOT EXISTS (SELECT 1                    FROM   A                    WHERE  A.ID = B.ID)

sql exists

The classical answer that works in almost every environment is

SELECT ID, Name, blah, blahFROM TableB TBLEFT JOIN TableA TAON TB.ID=TA.IDWHERE TA.ID IS NULL

sometimes NOT EXISTS may be not implemented (not working).

sql exists

If you are set on using EXISTS you can use the below in SQL Server:

SELECT * FROM TableB as bWHERE NOT EXISTS(   SELECT * FROM TableA as a   WHERE b.id = a.id)

CodeHunter