Dears,
Oracle 8 don’t support ANSI syntax with :
SELECT e.emp_id,
e.fname,
e.lname,
j.jobdesc
FROM employe e
LEFT JOIN jobs j ON e.job_id = j.job_id
but only
SELECT e.emp_id,
e.fname,
e.lname,
j.jobdesc
FROM employe e,
jobs j
WHERE j.job_id (+) = e.job_id
JOIN syntax came with 9i.
Anyone patched Rails source for supporting that (+) ‘theta’ style ?
I’m using 8.1.7 and LEFT JOIN is builded into class
HasAndBelongsToManyAssociation to provide HABTM
Thanks!
–
Mathieu