Difference between JOIN and UNION in SQL
JOINs are used to retrieve data from two or more tables (Combine rows from multiple tables) based on logical relationships between the tables.
Note: There are 4 types of joins available in MS SQL Server. They are INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN.
UNION is used to combine multiple result sets into single result set. Each select statement which are using UNION must have the same number of columns in same order with compatible (similar) data types.
Note: By default UNION will return distinct records, to include duplicate values use UNION ALL.