|SQL - Structured Query Language|
SET operators are used to combine collection of queries results into a single result set. SQL join is used to combine collection of column(s) between two different tables with common associated column. Yet SET operator is used to combine collection of records among two or more tables. The number and the order of the columns must be the same in all SET operator queries and then data types must be compatible.
Note: For Demo, create Sales_Year_01 and Sales_Year_02 Tables and then INSERT sample records.
Query Output Screen
* * * * *