Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: simple query help

Re: simple query help

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 6 Jan 2000 15:29:02 GMT
Message-ID: <852cbu$j9k$2@news.seed.net.tw>

Alan Shein <alanshein_at_erols.com> wrote in message news:84t8hv$657$1_at_bob.news.rcn.net...
> Yes.
>
> a.dept(+) = b.dept
>
> or
>
> a.dept = b.dept(+)
>
> depending on what you want...

No.
You can not predicate which side is "larger". And more, you can not assume A is a superset of B, nor B is a superset of A.

Take look at a quick example:

dept dude status
==== ==== ======
north, bob, i,
east, mary, a, Received on Thu Jan 06 2000 - 09:29:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US