KnowledgeBase
a KnowledgeBase blog for my random thoughts and observations...
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment