SQL Server: Outer Join

Description

In SQL Server, an OUTER JOIN (LEFT, RIGHT, or FULL) retrieves records from one table even if there's no match in the other table. It includes unmatched rows with NULL values.

In this lab, you will learn how to use Outer Joins in SQL Server and their purposes.

Based on this Schema, generate the solutions to the respective queries listed below:

1. List all products and their total sales, including those that did not sell.
2. List all customers and the total amount they spent irrespective of whether they placed any orders or not.
3. List customers that have not placed orders.
4. Match all customers and suppliers by country.

Lab Objective

Upon completion of this lab, you will be able to:

• Gain Hands-On Experience on SQL Server Outer Joins.

Prerequisites

• You should have a conceptual understanding of Joins.
• You must have SQL Server Installed on your systems.