Wednesday, August 13, 2014

SQL JOIN to find non-matching rows


SELECT t1.ID 
FROM Table1 t1 LEFT JOIN Table2 t2 ON t1.ID = t2.ID 
WHERE t2.ID IS NULL

No comments:

Post a Comment