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