-- in写法 select * from A where A.id in (select bid from B ) and A.name in (select bname from B ) ; -- exits写法 select * from A where EXISTS (select 1 from B.bid = A.id );
mysql中in和exists的区别 -- in写法 select * from A where A.id in (select bid fromB ) and A.name in (select bname fromB ) ; -- exits写法 select * from A where...