RIGHT OUTER JOIN is used to combine two tables rows that it get all rows from table which is right side of the JOIN and matched rows from table which is left side of the JOIN. RIGHT OUTER JOIN also known as RIGHT JOIN. While using RGHTT JOIN left side table rows which does not have matched values with right side table then in the result set we get NULL values.

SELECT column1,column2,table2.column1,table2.column2,….
 FROM table1 RIGHT JOIN
table2 ON table1.column_name = table2.column_name;  

CREATE VIEW view_name AS column1,column2,coulumn3,…
FROM table1 RIGHT JOIN 
table2 ON table1.column_name = table2.column_name;    

DELETE table | view FROM table1  RIGHTJOIN
table2 ON table1.column_name = table2.column_name  [WHERE condition ]; 

UPDATE table|view SET column_name = value FROM table1 RIGHT JOIN 
table2 ON table1.column_name = table2.column_name[WHERE condition ]; 

consider employee_details and department_details tables are as follows -

Scenario – Creating view by using RIGHT JOIN.

Requirement – Creating employee_info view by using RIGHT JOIN ON employee_details and department_details tables. The query was as follows –

CREATE VIEW employee_info AS SELECT emp_id, emp_name,
department_details.dept_name FROM employee_details
RIGHT JOIN department_details ON 
employee_details.dept_id = department_details.dept_id; 

It is also written as follows and the output should be same in both cases.

CREATE VIEW employee_info AS SELECT emp_id, emp_name,
department_details.dept_name FROM employee_details
RIGHT OUTER JOIN department_details ON
employee_details.dept_id = department_details.dept_id; 

By executing above query we can get all rows of specific columns from department_details table and matched rows from employee_details table. The output was as follows -

Scenario – Creating view by using RIGHTT JOIN without matching values in another table.

Requirement – Creating employee_info view by using RIGHT JOIN ON employee_details and department_details tables. The query was as follows –

let us consider we have department table as follows –

CREATE VIEW employee_info AS SELECT emp_id, emp_name, 
department.dept_name FROM employee_details
RIGHT  JOIN department ON
employee_details.dept_id = department.dept_id; 

By executing we can get all details from department table which is right side of the JOIN and matched values from left side table but There is no matched values in the employee_details table. So in the result set we can get NULL values in result set.

Scenario – Deleting table by using RIGHT JOIN.

Requirement – Deleting employee_details table by using RIGHT JOIN. The query was as follows–

DELETE employee_details FROM employee_details
RIGHT JOIN department_details ON 
employee_details.dept_id = department_details. dept_id; 

By executing above query we can delete all details of employees in employee_details table whose dept_id match with the department_details table dept_id by using RIGHT JOIN. The output was as follows –

Scenario – Updating table by using RIGHT JOIN.

Requirement – Updating date_of_hire of all employees in employee_details table by using RIGHT JOIN. The query was as follows –

UPDATE employee_details SET date_of_hire ='2019-09-09'
 FROM employee_details
RIGHT JOIN department_details ON
employee_details.dept_id = department_details. dept_id; 

By executing above query we can update all employees date_of_hire with 2019-09-09 on employee_details whose dept_id match with dept_id of department_details table by using RIGHT JOIN. The output was as follows -

Scenario – Getting details from two tables by using RIGHT JOIN.

Requirement - Getting details from employee_details, department_details tables by using RIGHT JOIN. The query was as follows –

SELECT emp_id,emp_name,designation,salary,department_details.dept_name
FROM employee_details RIGHT JOIN department_details ON
employee_details.dept_id = department_details.dept_id; 

By executing above query we can get matching rows in employee_details with department_details table and all details from department_details table. The output was as follows -