If you are looking for rows in Table1 that are not in Table2, you can do this:SELECT Table1.NameFROM Table1WHERE 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 Tbl2NameFROM Table2 FULL JOIN Table1 ON Table2.Name = Table1.NameWHERE Table1.Name IS NULL OR Table2.Name IS NULL;
In a similar way, the first query could be rewritten to use a left join.