|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.
Query Output Screen
* * * * *