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 PostgreSQL

Get to know the data
5. Get to know the equipment table
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
Aliases for tables

Instruction

Finally, the third table: equipment. Check the contents of the table.

Exercise

Get all the data from the equipment table.

Stuck? Here's a hint!

Type:

SELECT *
FROM equipment;