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
Referencing columns
7. Display specific columns
Let's practice

Instruction

Splendid! Now, let's say we only need a few columns in our result. We just want to know the model of the car and the owner's name, Take a look:

SELECT
  person.name,
  car.model
FROM person
JOIN car
  ON person.id = car.owner_id;

Simple, isn't it? Instead of the asterisk (*), we put the column names.

As we now have more than one table, we put the table name in front of the column name and we separate them with a dot (.). In this way, SQL knows that the column model belongs to the car table, etc.

Exercise

Select director name and movie title from tables movie and director in such a way that a movie is shown together with its director.

Stuck? Here's a hint!

Type:

SELECT
  movie.title,
  director.name
FROM movie
JOIN director
  ON movie.director_id = director.id;