Difference between JOIN and UNION in SQL:
JOIN – JOIN helps in the combination of data from multiple tables on the basis of a matched condition present between them. It would combine the available data into new columns.
UNION – SQL helps in the combination of the result-set of multiple SELECT statements. It would combine the available data into new rows.