站长资源网络编程

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

整理:jimmy2024/10/27浏览2
简介select UserName from TableA where UserName not in (select UserName from TableB where TableA.UserName=TableB.UserName) order by UserName desc
select UserName from  TableA where UserName not in (select UserName from TableB where TableA.UserName=TableB.UserName) order by UserName desc