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: odd sub-select problem

Re: odd sub-select problem

From: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Mon, 29 Oct 2001 20:37:00 +0100
Message-ID: <9rkb2j$c7v$1@wanadoo.fr> 






"Daniel Schmolze" <usenet_at_schmolze.com> a écrit dans le message news:
12bb17fa.0110291011.32821eff_at_posting.google.com...


> SELECT NAME FROM A


> WHERE NAME IN (SELECT NAME FROM A)


>

> (In other words, show me all the names in A that *are* in B)

You wrote "... that *are* in A".



>

> I get about 1500 rows, as expected. Can anyone shed some light on

> this?

>

> Thanks.

Received on Mon Oct 29 2001 - 13:37:00 CST












Original text of this message













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