StationX
Start free

Browse › T-SQL Database Query

Querying Multiple Tables Using Outer Joins in Transact-SQL

Guided

Part of T-SQL Database Query Topic: Data Science

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this lab, your will write several Transact-SQL queries to join data from multiple tables by using outer joins.

  1. Launch Microsoft® SQL Server® Management Studio (SSMS)
  2. Compare inner and outer joins
  3. Develop more specific queries that include joining tables by using multiple outer joins
  4. Explore queries that join tables using multiple join type Note: Once you begin the lab, you will not be able to pause, save, or exit and then return to your lab
  5. Please ensure that you have set aside enough time to complete the lab before you start
  • ⏱ About 60 minutes