Greenplum Confidential
5
The syntax for an INNER JOIN is simple!
Also known as a SIMPLE JOIN or EQUI-JOIN.
SELECT
EMP.EMPLOYEE_ID
, EMP.EMPLOYEE_NAME
, DPT.DEPT_NAME
FROM
EMPLOYEES EMP
, DEPARTMENTS DPT
WHERE
EMP.DPT_ID = DPT.DPT_ID;
This query only retrieves rows based on the following join condition:
a corresponding row must exist in each table,
thus the term ―INNER JOIN‖.
Inner Join