Home
C
Java
SQL
PostgreSQL
HTML
CSS
JavaScript
jQuery
Ajax
Android
Python
Quiz
Projects
Interview Q
Comment
Forum
Training

Right Outer Join

The right outer join returns all rows from the right hand table specified in the ON condition and only those rows from the other table where the inner join condition is true.

The right outer join is absolute opposite of left outer join.

Image representation:

Syntax:

SELECT table1.columns, table2.columns
FROM table1
RIGHT OUTER JOIN table2
ON table1.common_filed = table2.common_field;

See this example:

Let's take a table "EMPLOYEES" having the following data.

Table1: EMPLOYEES

Create another table "DEPARTMENT" having the following data.

Table2: DEPARTMENT

Execute the following query:

 SELECT "EMPLOYEES"."ID", "EMPLOYEES"."NAME", "DEPARTMENT"."DEPT"
FROM "EMPLOYEES" 
RIGHT OUTER JOIN "DEPARTMENT"
ON "EMPLOYEES"."ID" = "DEPARTMENT"."ID";

Output:

Next TopicPostgreSQL Full Join

← prev next →

PostgreSQL Tutorial

PostgreSQL Database

PostgreSQL Table

PostgreSQL Schema

PostgreSQL Queries

PostgreSQL Clause

PostgreSQL Conditions

PostgreSQL Views

PostgreSQL Join

PostgreSQL Advance

Interview

Quiz

Right Outer Join