exists 和 in区别 当A变数据大于B表数据 用exists ;反之用in select * from A where exists (select 1 from Bwhere A.id = B.id)