可以使用NOT EXISTS運算子來轉換. EX: DECLARE @R Table (a INT,b INT) DECLARE @S Table (a INT,b INT) INSERT INTO @r VALUES (1,5) INSERT INTO @r VALUES (1,2) INSERT INTO @r VALUES (1,6) INSERT INTO @r VALUES (2,0) INSERT INTO @r VALUES (2,2) INSERT INTO @r VALUES (2,5) INSERT INTO @r VALUES (3,3) INSERT INTO @r VALUES (3,2)INSERT INTO @s VALUES (2,5) INSERT INTO @s VALUES (2,2) INSERT INTO @s VALUES (2,0) --@R/@S結果應該是2,為了方便@S我加了a字段,其實可以拆開轉到另一個關系的 select distinct a.a from @r a where not exists (select * from @s b where not exists (select * from @r where b=a.b and a.a=b.a ) )
EX:
DECLARE @R Table (a INT,b INT)
DECLARE @S Table (a INT,b INT)
INSERT INTO @r VALUES (1,5)
INSERT INTO @r VALUES (1,2)
INSERT INTO @r VALUES (1,6)
INSERT INTO @r VALUES (2,0)
INSERT INTO @r VALUES (2,2)
INSERT INTO @r VALUES (2,5)
INSERT INTO @r VALUES (3,3)
INSERT INTO @r VALUES (3,2)INSERT INTO @s VALUES (2,5)
INSERT INTO @s VALUES (2,2)
INSERT INTO @s VALUES (2,0)
--@R/@S結果應該是2,為了方便@S我加了a字段,其實可以拆開轉到另一個關系的
select distinct a.a from @r a
where not exists
(select * from @s b
where not exists
(select * from @r
where b=a.b and a.a=b.a
)
)