Too much free time - ANSII SQL question
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
I'm stmontgo and I approve of this message