|
|
|
| SQL - Structured Query Language |
Full Outer JoinFull 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 |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR