SQL RIGHT JOIN Keyword

[seezorr]

The RIGHT JOIN keyword works the same way as LEFT JOIN keyword except that it returns all rows from the right table. This means that even there is no matching record from the left join the rows will still show from the second table.

SQL RIGHT JOIN Syntax

SELECT

column_name(

s)

FROM

First_table_name RIGHT

JOIN

Second_table_name ON

First_table_name.

column_name =

Second_table_name.

column_name

Consider the following table for this exercise

Users

Firstname

Lastname

Salary

DeptID

John

Smith

1000

1

Mathew

Simon

3000

1

Bill

Steve

2200

1

Amanda

Rogers

1800

2

Steve

Hills

2800

2

Steve

jobs

2400

2

bill

cosby

700

3

Departments

DeptID

DepartmentName

1

Employee

2

Staff

3

Management

4

HR

Example # 1

SELECT

Firstname,

Lastname,

Salary,

DepartmentName FROM

Users RIGHT

JOIN

Departments ON

Users.

DeptID =

Departments.

DeptID

Result of the Query

Firstname

Firstname

Salary

DepartmentName

John

Smith

1000

Employee

Mathew

Simon

3000

Employee

Bill

Steve

2200

Employee

Amanda

Rogers

1800

Staff

Steve

Hills

2800

Staff

Steve

jobs

2400

Staff

bill

cosby

700

Management

HR

We have joined the two tables, and in the WHERE clause we are matching the primary keys and the foriegn keys from both tables.