Javatpoint Logo
Javatpoint Logo

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

 postgresql inner-join1

Syntax:

PostgreSQL INNER JOIN Example

Table1: EMPLOYEES

PostgreSQL Inner Join

Table2: DEPARTMENT

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

postgresql join

Execute the following query:

Output:

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

postgresql join



Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA