|SQL - Structured Query Language|
Joins with Clause
Join query can define with WHERE clause that used to retrieve list of common columns matched data value records between child and parent tables with a criteria. The following inner join query is used to retrieve EMP table�s particular record that matched with DEPT table's record. The common colum is DEPT_CODE and the criteria is Employee Name.
Query Output Screen
* * * * *