数据查询问题

[luyiroger]

有两个表 ls1 和ls2
ls1:

a01 a02
1001 6073
1002 60731
1003 607311

ls2:

b01 b02
5001 607311111
5002 6073


我想把ls1和ls2中的 1001, 6073,5002 这条结果查找出来

之前我用 sele * from ls1 where ls1.a02 in (sele b02 from ls2)
好像ls1中的记录都会查找出来

[lygcw9602]

是查LS1.A01='1001' LS2.B01='5002' 中都包含'6073'的数据吧

[lygcw9602]

CREATE CURSOR ls1 (a01 c(4),a02 c(10))
INSERT INTO ls1 VALUES ('1001','6073')
INSERT INTO ls1 VALUES ('1002','60731')
INSERT INTO ls1 VALUES ('1003','607311')
CREATE CURSOR ls2 (b01 c(4),b02 c(10))
INSERT INTO ls2 VALUES ('5001','607311111')
INSERT INTO ls2 VALUES ('5002','6073')

SELECT * FROM (SELECT * FROM ls1 UNION select * FROM ls2) a WHERE INLIST('6073',a02) AND INLIST(a01,'1001','5002')

最后显示结果
A01    A02
1001   6073
5002   6073