[OJB-developers] INNER JOIN syntax

[Oleg N. <on...@uk...>]

Hi All,

I propose to use equatilies in WHERE clause for INNER JOINs.
I mean that instead of 
1) SELECT ... FROM (A INNER JOIN B ON A.FK=B.ID) INNER JOIN C ON B.FK=C.ID
we can generate
2) SELECT ... FROM A, B, C WHERE A.FK=B.ID AND B.FK=C.ID
I don't know any RDBMS that doesn't support the 2nd syntax.
Does anybody knows one?
But I know the RDBMS that doesn't support the 1st syntax: HSQL.
To be more precise, HSQL does not support nested joins such as above. 
Maybe it supports some other flavor of 1st syntax, but let's don't increase 
complexity if we can use 2nd syntax in all cases.
And the 2nd syntax seems shorter and simpler.

Regards,
 Oleg