-------------------------------
-- SET Operators
-------------------------------
CREATE TABLE zugi
(id int)
CREATE TABLE ee_zugi
(id int)
INSERT INTO zugi VALUES (1) , (2) , (4) , (6) , (8) , (10)
INSERT INTO ee_zugi VALUES (1) , (3) , (5) , (7) , (9) , (10)
SELECT * FROM zugi
SELECT * FROM ee_zugi
SELECT id FROM zugi
UNION ALL
SELECT id FROM ee_zugi
SELECT id FROM zugi
UNION
SELECT id FROM ee_zugi
SELECT id FROM zugi
INTERSECT
SELECT id FROM ee_zugi
SELECT id FROM zugi
EXCEPT
SELECT id FROM ee_zugi
SELECT id , 'ee_zugi' AS 'mashatarotse' FROM ee_zugi
UNION ALL
SELECT id , 'zugi' FROM zugi
SELECT city FROM customers
UNION
SELECT ShipCity FROM orders
SELECT productID , productName , unitPrice FROM products WHERE unitPrice > 50
EXCEPT
SELECT productID , productName , unitPrice FROM products WHERE productName LIKE '%a%'
SELECT productID , productName , unitPrice FROM products WHERE unitPrice > 50
INTERSECT
SELECT productID , productName , unitPrice FROM products WHERE productName LIKE '%a%'
SELECT ShipCity , 'Orders' FROM Northwind.dbo.orders
UNION ALL
SELECT cityname , 'Cities' FROM [AdventureWorks2012].[dbo].[city]
