If you are looking for rows in Table1 that are not in Table2, you can do this:SELECT
Table1.Name
FROM
Table1
WHERE
NOT EXISTS
(
SELECT * FROM Table2
WHERE Table2.Name = Table1.Name
)
If you want to find names that are in one table but not in the other, you can use a full join.
SELECT
Table1.Name AS Tbl1Name,
Table2.Name AS Tbl2Name
FROM
Table2
FULL JOIN Table1
ON Table2.Name = Table1.Name
WHERE
Table1.Name IS NULL
OR Table2.Name IS NULL;
In a similar way, the first query could be rewritten to use a left join.
SQL query - finding non-matching data in a table
Posted - 06/22/2011 : 06:14:02
