access数据库"A"表中"a字段",与"B"表中"b字段"进行关联,想查找"a字段"中包含"b字段"的记录,如何查询??

Question

如题所述

Answer 1

instr('abc','b')这个写法
select A.a from A WHERE EXISTS (SELECT 1 FROM B WHERE instr(A.a,B.b) > 0)追问

您的方法可行,如果要同时输出字段"a","b"要怎么操作?

本回答被提问者采纳

Answer 2

SELECT * FROM A WHERE A.a IN (SELECT B.b FROM B)

Answer 3

SELECT A.a from A WHERE A.a IN B.b