Check if entry in table A exists in table B

January 4, 2023 by Tarik

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