|SQL - Structured Query Language|
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.
Query Output Screen
* * * * *