I'd like to compare two tables, and show values found in table 1 which are NOT in table 2, then same for table 2, show values in table 2 which are NOT in table 1.
Here's what I came up with, looks ok?
select T1.[Name], T2.[Address]
from [dbo].[My Table 1] as T1
left join [dbo].[My Table 2] as T2 on T1.[Name]=T2.[Name]
where T2.[Address] is not null