|SQL - Structured Query Language|
UNION operator combines the results of two or more queries into a single result set that includes all records that belong to all queries in the UNION. The number and the order of the columns must be the same in all UNION queries and then data types must be compatible. UNION operator ignores duplicate records. The following UNION query is used to combine Sales Year 01 and 02 records.
Query Output Screen
* * * * *