select * from a where a.pro_id not in(select pla_id from b )
1、select * from a where pro_id not in (select pla_id from b)
2、select * from a where not exists(select 1 from b where b.pla_id=a.pro_id)
3、select t1.* from a left join b on a.pro_id=b.pla_id where b.pla_id is null
select * from a where pro_id=5 or pro_id=6
select * from a where pro_id in (5,6);
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024