select UserName from TableA where UserName not in (select UserName from TableB where TableA.UserName=TableB.UserName) order by UserName desc 【说明】:本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!