注册 登录
编程论坛 VFP论坛

两表相同记录筛选

fdqzy 发布于 2020-07-08 15:58, 1060 次点击
create cursor b1 (jnh n(1),mc c(2))
insert into b1 values (1,"A1")
insert into b1 values (2,"A2")
insert into b1 values (3,"A3")
insert into b1 values (4,"A4")
insert into b1 values (5,"A5")

create cursor b2 (jnh n(1),mc c(2))
insert into b2 values (1,"A2")
insert into b2 values (2,"A5")
insert into b2 values (3,"C1")
 在b1中查mc与b2中mc相同的记录。谢谢!
2 回复
#2
sdta2020-07-08 16:02
SELECT * FROM b1 WHERE mc in (SELECT mc FROM b2)
#3
fdqzy2020-07-08 16:05
谢谢版主!
1