删除A表中在B表中不存在的数据
select UserName from TableA where UserName not in (select UserName from TableB where TableA.UserName=TableB.UserName) order by UserName desc
内容版权声明：除非注明，否则皆为本站原创文章。