SQL Server: Full Outer Join

Level : Beginner
Mentor: Shailendra Chauhan
Type : GuidedLab
Points : 10
Duration : 00:15:00

Lab Details


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:

  1. List all customers and their order dates, including those without orders.
  2. 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 Full Joins.


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

Self-paced Membership
  • 22+ Video Courses
  • 800+ Hands-On Labs
  • 400+ Quick Notes
  • 55+ Skill Tests
  • 45+ Interview Q&A Courses
  • 10+ Real-world Projects
  • Career Coaching Sessions
  • Email Support
Upto 60% OFF
Know More
Still have some questions? Let's discuss.
Accept cookies & close this