Lack of 'LEFT JOIN' in Oracle 8, any patch for theta style (


#1

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


#2

On 5-dec-2005, at 17:24, Mathieu C. wrote:

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

This OT but funny because sqlite3 does not support RIGHT JOIN. So we
actually have NO DB-agnostic joins :slight_smile:


Julian ‘Julik’ Tarkhanov
me at julik.nl