34,838
社区成员




select * from Y
where not exists(select 1 from X where X.a1=Y.a1 and X.a2=Y.a2)
declare @a table (a1 varchar(10),a2 varchar(10))
insert into @a select '01','a'
insert into @a select '01','b'
insert into @a select '02','a'
insert into @a select '02','b'
insert into @a select '03','a'
declare @b table (a1 varchar(10),a2 varchar(10))
insert into @b select '01','a'
insert into @b select '01','b'
insert into @b select '02','a'
insert into @b select '02','b'
insert into @b select '03','a'
insert into @b select '03','b'
select * from @b y where
not exists(select 1 from @a where a1=Y.a1 and a2=Y.a2)
select * from Y where not exists(select 1 from X where a1=Y.a1 and a2=Y.a2)