SQL - Structured Query Language

Full Outer Join



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

-- Example 35 --

 

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

FROM EMP

FULL OUTER JOIN DEPT

ON EMP.Dept_Code = DEPT.Dept_Code


Query Output Screen



* * * * *


Email Your Comment To AUTHOR