27,582
社区成员




--创建临时表
DECLARE @TABLEA TABLE (ID INT,QTY INT ,UP DECIMAL(19,9))
INSERT INTO @TABLEA
SELECT 1,1,1.5 UNION ALL
SELECT 1,100,1.25 UNION ALL
SELECT 2,1,2.5 UNION ALL
SELECT 2,100,2.25
DECLARE @TABLEB TABLE (ID INT,QTY INT ,UP DECIMAL(19,9))
INSERT INTO @TABLEB
SELECT 1,56,1.25 UNION ALL
SELECT 1,100,1.25 UNION ALL
SELECT 2,1,2.5 UNION ALL
SELECT 2,123,2.5
--查询表B不符合表A的数据
SELECT * FROM @TABLEB AS B
WHERE NOT EXISTS(SELECT 1 FROM @TABLEA AS A WHERE B.ID=A.ID AND B.QTY=A.QTY AND B.UP=A.UP)