Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics in MS SQL Server

Get to know the data
JOIN revisited
LEFT JOIN
RIGHT JOIN
14. RIGHT JOIN again
FULL JOIN
OUTER JOINS
Aliases for tables

Instruction

Very nice! Let's do one more exercise.

Exercise

Show the room each student is assigned to. Show all students, even those who are not assigned to any room. Use a RIGHT JOIN.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM Room
RIGHT JOIN Student
  ON Student.RoomID = Room.ID;