Question: what is the difference between union and join in sql server?
Answer: The join such as INNER JOIN or LEFT JOIN combines columns from two tables while the UNION combines rows from two queries. In other words, join appends the result sets horizontally while union appends result set vertically.