Quick Reference - PostgreSQL Joins

20 Jun 2022

INNER JOIN

The INNER JOIN keyword selects records that have matching values in both tables.

LEFT JOIN

The LEFT JOIN keyword returns all records from the left table and all records from the right table. If there is not matching record in the right table the value of the column will be NULL.

RIGHT JOIN

The RIGHT JOIN keyword returns all records from the right table and all records from the left table. If there is not a matching record in the left table the value of the column will be NULL.