declare @foo as table (foo int)
declare @foo2 as table (foo int)

insert into @foo select 1 union select 2 union select 5
insert into @foo2 select 1 union select 2 union select 4

select * from @foo
union
select * from @foo2
except
select * from @foo
intersect
select * from @foo2