how do i write this query in ANSI?

ok. i am converting all my old non-ansi sql to sql code and ran across one that i didnt know how to convert in ansi....


select * from table a, table b where a.column(+)=b.column

converts to

select * from table b left outer join a ON (a.column=b.column)

cool..... but what do i do when i have a table that is the strong table on 1 outer join and then the weak table on another? i cant just declare it twice cuz i get table already defined...

how would i convert......

select * from table a, table b, table c
where a.column(+)=b.column AND
b.column(+)=c.column

?

fair enough... but i forgot to mention that tables A and table C
do not have a common column...

i didnt mean for it to appear that the "column" was the same column...

let me rewrite the query to be...

select * from table a, table b, table c
where a.column(+)=b.column AND
b.column2(+)=c.column2

Why would that matter really?

i guess that looked to me like i would be LEFT JOINING C to A when there was no relation

i guess thats right.