Question: what is the difference between merge join and union (sql-server)?
Answer: Both joins and unions can be used to combine data from one or more tables into a single result. They both go about this is different ways. Whereas a join is used to combine columns from different tables, the union is used to combine rows.