PostgreSQL Joins

A join in any relational databases including PostgreSQL is used to combine columns from one or more tables based on the values of the common columns between the tables. The most common columns used to join tables are the primary key and foreign key columns. PostgreSQL supports inner join, left join, right join, full outer join, cross join, natural join, self-join, and a lateral join.