56,679
社区成员
发帖
与我相关
我的任务
分享
select *
from member_table b left join user_email a on A.user_email = B.member_id
where a.user_email is null
select *
from member_table
where not exists (select 1 from user_email where user_email=member_table.member_id)