56,940
社区成员




select ID from 表1 where name='小王' AND id not in ( select id from 表2 )
select ID from 表1 where name='小王' AND EXISTS( SELECT * from 表2 where ID= 表1.ID
select ID from 表1 where name='小王'
WHERE EXISTS( SELECT * from 表2 where ID= 表1.ID
select ID from 表1 where name='小王' where id not in ( select id from 表2 )