SQL - Structured Query Language

Inner Join



Inner 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



* * * * *


Email Your Comment To AUTHOR