Sunday, November 13, 2016

SQL select where join not existed; Select where can't join

SELECT t1.ID
FROM Table1 t1
    LEFT JOIN Table2 t2 ON t1.ID = t2.ID
WHERE t2.ID IS NULL
source: http://stackoverflow.com/a/4076157/1767461