Re: FULL JOIN syntax vs (+)

Użytkownik "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> napisał w wiadomości news:bou7gl$d7c$1$830fa78d_at_news.demon.co.uk...
>
> I think this is the correct starting point:
>
>
> select {list of column}
> from
> a, b
> where
> b.id(+) = a.id -- preserve A
> union all
> select {list of columns}
> from
> b,1
> where
> a.id(+) = b.id -- preserve B
> and a.id is null -- discard inner join result
> ;

You sure that 'union all' doesn't duplicate rows in query results when a.id = b.id ???
I prefer simple 'union' in this example.

--
Noel