intersection in sql

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

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
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