So I got nothing better to do today so I'm messing with some ANSII sql.

Why would you ever want to use the ON clause?

For example, if I could use

SELECT e.employee_id, e.last_name, d.location_id
FROM employees e JOIN departments d USING (department_id)

Tnen why would I even think of using


SELECT e.employee_id, e.last_name, d.location_id
FROM employees e JOIN departments d ON (e.department_id = d.department_id)

The 9i new features book says using the ON clause makes your SQL code easier to read.

Any thoughts?

Thanks much