2018年3月6日
SQLServer两张表筛选相同数据和不同数据
摘要： select distinct A.ID from A where A.ID not in (select ID from B) select A.ID from A left join B on A.ID=B.ID where B.ID is null select * from B where (select count(1) as num from A where A.ID = ... 阅读全文
posted @ 2018-03-06 19:17 chenjingchun 阅读(581) 评论(0) 推荐(0)