I've got this query in the "old" join Oracle syntax.



SELECT

T1.C1,

T2.C1,

T3.C1

FROM

TABLE_1 T1, TABLE_2 T2, TABLE_3 T3

WHERE

T1.C2 = T2.C2

AND

T1.C2 = T2.C2





I want to re-write it in the "new" ANSI syntax. The following does not work.
The problem seems to be in the specification of more than two joined tables.
How do I specify more than two tables to join using the new ANSI syntax? The
column names are not the same so I cannot use the "USING" clause.



SELECT

T1.C1,

T2.C1,

T3.C1

FROM

TABLE_1 T1 INNER JOIN TABLE_2 T2 AND TABLE_1 T1 INNER JOIN TABLE_3
T3

ON

T1.C2 = T2.C2

AND

T1.C2 = T3.C2



Thanks

J.

Shouldn't it be something like:

Hilarion