SQL Server: Left Outer Join

Description

LEFT JOIN in SQL Server retrieves all rows from the left table and matching rows from the right table, with NULL values where no match is found.

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

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

1. List all suppliers and their products, including suppliers with no products.
2. List all customers and the total amount they spent irrespective of whether they placed any orders or not.

Lab Objective

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

• Gain Hands-On Experience on SQL Server Left Outer Join.

Prerequisites

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