select a.*
from wx_nickname a
left join (select distinct nickname_id from wx_group_nickname )b on
a.id = b.nickname_id
where b.nickname_id is null

746 total views, 1 views today

发表评论

电子邮件地址不会被公开。 必填项已用*标注