Select [Name] From Text1 Where [Name] Not In (Select [test1.Name] From Test1 Inner Join Test2 On Test1.Name = Test2.Name) Union ( Select [Name] From Text2 Where [Name] Not In (Select [test1.Name] From Test1 Inner Join Test2 On Test1.Name = Test2.Name) ) Order By [Name]
select [name] from test1 where [name] not in (select [name] from test2) union ( select [name] from test2 where [name] not in (select [name] from test1) ) order by [name]
Union (
Select [Name] From Text2 Where [Name] Not In (Select [test1.Name] From Test1 Inner Join Test2 On Test1.Name = Test2.Name)
)
Order By [Name]
union (
select [name] from test2 where [name] not in (select [name] from test1)
)
order by [name]