Database JOINS in PostgreSQL

JOINS are queries that access multiple tables (or multiple instances of the same table) at one time by combining rows from one table with the rows from a second table with an expression specifying which rows are to be paired (PostgreSQL documentation...