位置: sql语句取并集 - 标签
SQL语句的并集UNION 交集JOIN(内连接，外连接)等介绍(sql语句取并集)
简述:1.a.并集UNIONSELECTcolumn1,column2FROMtable1UNIONSELECTcolumn1,column2FROMtable2b.交集JOINSELECT*FROMtable1ASaJOINtable2bONa.name=b.namec.差集NOTINSELECT*FROMtable1WHEREnameNOTIN(SELECTnameFROMta