若A里的a字段要等于B中的b字段就用1L的写法，若是包含就这么写select * from A where exists(select 1 from B where A.a like '%'+B.b+'%')
不能like，要用inselect * from A where a in (select b from B);
like 这么用好像还真不行~~
