A good solution, but it assumes that table 2 is a subset of table 1. This may be true, but is not explicitly said, So if in the above example table 2 also contained 'brian', then 'brian' would be missing from the output. The addition of a union would fill in any rows in table 2 but not in table 1

select t1.name, t2.name 
from t1
left outer join t2 on t1.name = t2.name
union
select t2.name, t1.name
from t2
left outer join t1 on t2.name = t1.name
where isnull(t1.name)
[download]