Re: [OJB-developers] INNER JOIN syntax

[James T. <jt...@4l...>]

Just wanted to point out that oracle 8(i) supports neither INNER JOIN
nor OUTER JOIN syntax. Just the ( foo = bar ) and ( foo = bar(+) )
forms. My apologies if that is not relevant to the current discussion of
SQL generation, I'm jumping onto the list mid-thread.

-- jt

On Mon, 2002-05-06 at 04:16, Jakob Braeuchi wrote:
> hi,
> 
> mysql also optimises joins
> http://www.mysql.com/doc/L/E/LEFT_JOIN_optimisation.html
> so i think we should stick to the JOIN-syntax wherever possible.
> 
> jakob
>