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