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
6. Get to know the Equipment table – continued
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
Aliases for tables

Instruction

Good. The Equipment table is very much similar to the Student table. It has three columns:

  • ID – the ID of the piece of equipment.
  • Name – the name of the piece of equipment.
  • RoomID – the room in which the piece of equipment can be found.

Note that some pieces aren't assigned to any room – they are simply stored in the warehouse, if you're interested.

Exercise

Click Next exercise to continue.