Re: Complex outer joins?

On Mon, 24 Mar 2003, Correia, Carla wrote:

>  My problem is joins. I've seen the syntax on joins and have sucessefully
> used SQLs with joins, but I've got some other big SQL statements using many
> and complex
>  joins.
> Simplified example:
>
>  select G.SELID, G.TEXT,
>      L.ID as SELLEVELID , L.SELLEVEL, L.LEVELJOIN, L.LEVELTEXT,
>      C.ID as KRITERIENFELDID, C.SELFLD
>   from  G,  L,  C
>   where
>      and G.SELID = L.SELID (+)
>      and L.SELID = C.SELID (+)
>      and L.SELLEVEL = C.SELLEVEL (+)
>
> How can i write this in Postgres? As the problem is that I use one same
>  table for varios joins. This is a problem in Postgres. Any ideas?

I don't really understand the question, it looks like two levels of outer
join to me, the first between g and l using selid and the second between
that and c using selid and sellevel.  What do you mean "one same table for
various joins"?