|
|
|
| SQL - Structured Query Language |
Inner JoinInner join is used to retrieve list of common columns matched data value records between child and parent tables. Common columns must define in the inner join query. The following inner join query is used to retrieve list of EMP table's records that matched with DEPT table's records. The common column is DEPT_CODE. -- Example 32 --
SELECT EMP.Emp_Code, EMP.Emp_Name, EMP.Dept_Code, DEPT.Dept_Name FROM EMP INNER JOIN DEPT ON EMP.Dept_Code = DEPT.Dept_Code Query Output Screen |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR