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

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

Instruction

Well done! It wasn't easy.

Let's practice some more!

Exercise

Select all pieces of equipment together with the room they are assigned to. Show each piece of equipment even if it isn't assigned to a room. Select all available columns.

Stuck? Here's a hint!

Type:

SELECT *
FROM equipment
LEFT JOIN room
  ON equipment.room_id = room.id;