Description
In SQL Server, a FULL JOIN retrieves all records from both the left and right tables. If no match is found for a record in one table, NULL values are filled in for the other table.
In this lab, you will learn how to use Full Outer Joins in SQL Server.
Based on this Schema, generate the solutions to the respective queries listed below:
Lab Objective
Upon completion of this lab, you will be able to:
Prerequisites