Union intersect except T in SQL Server

When the structures of the two datasets are the same, you can add, subtract (minus), submit, and operate the set. The following uses SQL Server as an example.

 
 Set Addition 
 

 Union all (two sets are directly added, and repeated values are allowed)
 

 
 Select * From Table1 Union all select * From Table2 
 

 Set Union 
 

 
 Union (Union of two sets)
 

    select * From Table1     

 Union select * From Table2 
 

 
Set intersection 
 

 
 Intersect (intersection of two sets)
 

 Select * From Table1 intersect select * From Table2 
 

 
 Set Subtraction 
 

 Except (subtraction of two sets) 
 

 
 (Select * From Table1 Union select * From table2) distinct T (select * From Table1 intersect select * From Table2