Use Set Operators to combine rows from several tables into a single results.
Throughout this blog we have written articles to show you how to combine rows from tables using operators. These are UNION, INTERSECTION, and EXCLUDE.
If you are not familiar with how to use set operators, I would start with the article Learn to use Union, Intersect, and Except Clauses.
One of our most popular article looks at the difference between a Join and UNION. This is something people often confuse, so it is worth a read!
All the examples for this lesson are based on Microsoft SQL Server Management Studio. They use the sample databases AdventureWorks and WideWorldImporters. You can get started using these free tools using my guide Getting Started Using SQL Server