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