删除A表中在B表中不存在的数据

---

select UserName from TableA where UserName not in (select UserName from TableB where TableA.UserName=TableB.UserName) order by UserName desc

---

« 
» 

---