PostgreSQL JOIN

In PostgreSQL, there are following types of joins:

• The INNER JOIN
• The LEFT OUTER JOIN
• The RIGHT OUTER JOIN
• The FULL OUTER JOIN
• The CROSS JOIN

PostgreSQL INNER JOIN

The PostgreSQL Inner Join is also known as join or simple join. This is the most common type of join. This join returns all rows from multiple tables where the join conditions are satisfied.

Image representation

Syntax:

PostgreSQL INNER JOIN Example

Table1: EMPLOYEES

Table2: DEPARTMENT

Create another table "DEPARTMENT" and insert the following values.

Execute the following query:

Output:

The following is the inner join of both table "EMPLOYEES" and "DEPARTMENT".