Inner Joins with More than Two Tables Using SQL/92

Suppose we have SQL/86 table join syntax:


SELECT c.first_name, p.name AS project, pt.name AS TYPE
FROM employees c, purchases pr, projects p, project_types pt
WHERE c.employee_id = pr.employee_id
AND p.project_id = pr.project_id
AND p.project_type_id = pt.project_type_id
ORDER BY p.name;

The above syntax can be mapped to SQL/92 as:


SELECT c.first_name, p.name AS project, pt.name AS TYPE
FROM employees c INNER JOIN purchases pr
USING (employee_id)
INNER JOIN projects p
USING (project_id)
INNER JOIN project_types pt
USING (project_type_id)
ORDER BY p.name;