集合的问题 - 编程论坛

#2

schtg2021-05-30 17:38

请试一试，是这个意思吗？
CREATE dbf T1(id n(3),name c(12),class n(3))
INSERT INTO T1 values(1,"AAA",1)
INSERT INTO T1 values(2,"AAB",1)
INSERT INTO T1 values(3,"AAC",1)
INSERT INTO T1 values(4,"AAD",1)
INSERT INTO T1 values(5,"AAE",1)

CREATE dbf T2(id n(3),name c(12),class n(3))
INSERT INTO T2 values(1,"AAA",1)
INSERT INTO T2 values(2,"AAB",1)
INSERT INTO T2 values(3,"AAF",2)
INSERT INTO T2 values(4,"AAD",3)
INSERT INTO T2 values(5,"AAE",3)

SELECT T1.* FROM T1 WHERE T1.name + ALLTRIM(STR(T1.class)) NOT IN (SELECT T2.name + ALLTRIM(STR(T2.class)) FROM T2)

#3

xuminxz2021-05-30 17:40

select * from dbf1 where xh not in (select xh from dbf2 ) into dbf dbf3

#4

sarge_xp2021-05-30 19:29

回复 3楼 xuminxz

不错的