Forum: Ruby on Rails Lack of 'LEFT JOIN' in Oracle 8, any patch for theta style (

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
F16def8015a7562a285c65a14be48540?d=identicon&s=25 mathieu.chappuis.lists (Guest)
on 2005-12-05 17:29
(Received via mailing list)
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
A2b2f4ee23989dc68529baef9cbddcd6?d=identicon&s=25 listbox (Guest)
on 2005-12-05 19:40
(Received via mailing list)
On 5-dec-2005, at 17:24, Mathieu Chappuis 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 :-)


--
Julian 'Julik' Tarkhanov
me at julik.nl
This topic is locked and can not be replied to.