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

How to query more than one table
Creating JOINs
6. Join tables using JOIN
Referencing columns
Let's practice

Instruction

Take a look at the following example:

SELECT *
FROM person
JOIN car
  ON person.id = car.owner_id;

We want to join the person and car tables, so we use the keyword JOIN between their names.

SQL must also know how to join the tables, so there is another keyword ON. After it, we set our condition: join only those rows where the id in person is the same as owner_id in car.

Exercise

Use the new construction JOIN ... ON to join rows from the movie and director tables in such a way that a movie is shown together with its director.

Stuck? Here's a hint!

Type:

SELECT *
FROM movie
JOIN director
  ON movie.director_id = director.id;