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