|SQL - Structured Query Language|
Left Outer Join
Left outer join is used to retrieve list of common columns matched and child table's NULL data value records between child and parent tables. Common columns must define in the left outer join query. The following left outer join query is used to retrieve list of EMP table's records that matched or null with DEPT table's records. The common column is DEPT_CODE.
Query Output Screen
* * * * *