2014年09月29日 | Wizzer | 评论 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 1,379 total views, 1 views today