Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

union SQL

SQL> SELECT  ID, NAME, AMOUNT, DATE
   FROM CUSTOMERS
   LEFT JOIN ORDERS
   ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID
UNION
   SELECT  ID, NAME, AMOUNT, DATE
   FROM CUSTOMERS
   RIGHT JOIN ORDERS
   ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID;
Source by www.tutorialspoint.com #
 
PREVIOUS NEXT
Tagged: #union #SQL
ADD COMMENT
Topic
Name
4+9 =