quote:

---

Originally posted by ldrenning
I am trying to write a query that would tell me that Kevin is the only record that doesn't exist in both tables ... like an outlier.

---

-- prepare test data
declare @TableA table (ID int, NAME varchar(10))

insert	@tablea
select	1, 'Tom' union all
select	2, 'George' union all
select	3, 'Richard'

declare @TableB table (ID int, NAME varchar(10))

insert	@tableb
select	1, 'Tom' union all
select	3, 'Richard' union all
select	4, 'Kevin'

-- find any single name
select		isnull(a.id, b.id) [id],
		isnull(a.name, b.name) [name]
from		@tablea a
full join	@tableb b on b.name = a.name
where		a.id is null
		or b.id is null

-- find any single name
select		id,
		[name]
from		(
			select	id,
				name
			from	@tablea
			union all
			select	id,
				name
			from	@tableb
		) q
group by	id,
		[name]
having		count(*) = 1