34,591
社区成员
发帖
与我相关
我的任务
分享
SELECT COLUMNS FROM D1 WHERE NOT EXSITS (
SELECT 1 FROM D2 WHERE D1.d1 = D2.d2
)
declare @D1 table (D1 int)
insert into @D1
select 1 union all
select 2 union all
select 3 union all
select 4
declare @D2 table (D2 int)
insert into @D2
select 2 union all
select 3 union all
select 5 union all
select 6
SELECT a.* FROM @D1 a LEFT JOIN @D2 b ON a.D1=b.D2
WHERE b.D2 IS NULL
/*
D1
-----------
1
4
*/
SELECT * FROM
(
SELECT d1 FROM D1
UNION ALL
SELECT d2 FROM D2
) a
GROUP BY d1
HAVING COUNT(*) = 1
select d1 from tb_D1
except
select d2 from tb_D2