CREATE CURSOR B1 (姓名 C(10), 地址 C(10))
INSERT INTO B1 VALUES ("张三", "北京")
INSERT INTO B1 VALUES ("李四", "上海")
INSERT INTO B1 VALUES ("王五", "成都")
INSERT INTO B1 VALUES ("周六", "杭州")
CREATE CURSOR B2 (姓名 C(10))
INSERT INTO B2 VALUES ("张三")
INSERT INTO B2 VALUES ("李四")
SELECT * FROM B1 WHERE 姓名 IN (SELECT * FROM B2) INTO TABLE B3
BROWSE