intersection in sql

Solutions on MaxInterview for intersection in sql by the best coders in the world

showing results for - "intersection in sql"
Lena
14 Mar 2018
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