Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL: Full outer join?
However, UNION is the slowest way to query, coz it execute full table scan.
Please correct me if I am wrong.
Thanks a lot.
regards,
JK
oraskm_at_yahoo.com (Sanjay Mishra) wrote in message news:<eca56b4a.0107100914.778008da_at_posting.google.com>...
> The UNION is the best thing you can do with Oracle8i to solve this
> problem. Oracle9i has a new syntax for full outer joins, which is the
> ANSI standard.
>
> select A.*, B.*
> from A FULL OUTER JOIN B
> ON A.pk = B.pk
>
> HTH,
> Sanjay
>
> onlyforposting_at_yahoo.com (Vikas Agnihotri) wrote in message news:<77e87b58.0107021920.287b3c03_at_posting.google.com>...
> > How can I write a SQL for the following 2-table join?
> >
> > Based on the PK, Table A has 0 or 1 matching values. Table B has 0 or
> > 1 matching values.
> >
> > i.e. where A.pk = B.pk(+) or B.pk = A.pk (+)
> >
> > Is the above valid? Or do I need
> >
> > select... where a.pk=b.pk(+)
> > union
> > select .... where b.pk=a.pk(+)
> >
> > Any other efficient approaches?
> >
> > Thanks
Received on Tue Jul 10 2001 - 23:02:06 CDT