1SELECT ID, NAME, Amount, Date
2 FROM Customers
3 LEFT JOIN Orders
4 ON Customers.ID = Orders.Customer_id
5INTERSECT
6 SELECT ID, NAME, Amount, Date
7 FROM Customers
8 RIGHT JOIN Orders
9 ON Customers.ID = Orders.Customer_id;
10