SQL - Structured Query Language

Right Outer Join



Right outer join is used to retrieve list of common columns matched and parent table's NULL data value records between child and parent tables. Common columns must define in the right outer join query. The following right outer join query is used to retrieve list of EMP table's records that matched with DEPT table's matched or null records. The common column is DEPT_CODE.

-- Example 34 --

 

SELECT EMP.Emp_Code, EMP.Emp_Name, EMP.Dept_Code, DEPT.Dept_Name

FROM EMP

RIGHT OUTER JOIN DEPT

ON EMP.Dept_Code = DEPT.Dept_Code


Query Output Screen



* * * * *


Email Your Comment To AUTHOR