SqlServer俩张表取差集、交集、并集
Union 获取两个表的合集并且自动过滤重复数据SELECT * FROM tableAUNION SELECT * FROM tableBUnion all 获取两个表的合集并且不过滤重复数据SELECT * FROM tableAUNION ALL SELECT * FROM tableBIntersect 获取两个表的交集SELECT * FROM tableAINTERSECTSELECT * FROM tableBEXCEPT获取俩个表的差集示例：..
