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: Better way?

Re: Better way?

From: Alan <alan_at_erols.com>
Date: Mon, 31 Jan 2005 09:57:56 -0500
Message-ID: <366vaiF4tul66U1@individual.net>

<y1799_at_yahoo.com> wrote in message
news:1107183275.368691.70610_at_f14g2000cwb.googlegroups.com...
> Hi ,
>
> my query does not work bad for the small tables but maybe exists
> something more productive:
> select F1 from A
> where F1 not in (select F1 from B)
>
> Thanks
>

SELECT f1 FROM a
MINUS
SELECT f1 FROM b Received on Mon Jan 31 2005 - 08:57:56 CST

Original text of this message

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