Question

sql怎么查询一个表里的数据在另一个表是否存在？

Answer 1

select * from swdj where qymc not in (select qymc from gsdj)