Re: Apparently I don't understand full outer joins....

Thanks guys, this works great.

On Tue, 25 Jan 2005, Stephan Szabo wrote:

> 
> Each outer join gets an on clause.  You might want something like:
> select
>         coalesce(a.n,0) as a,
>         coalesce(b.n,0) as b,
>         coalesce(c.n,0) as c,
>         coalesce(a.s,b.s,c.s) as s
> from
>         ( select 1 as n, 0 as s) a full outer join
>         ( select 1 as n, 1 as s) b on (a.s=b.s) full outer join
>         ( select 2 as n, 2 as s) c on b.s = c.s;
> 
>