RE: difference nested select union
Maybe the problem lies in the way you count? :-)
Ciao,
Marco
____________________________________________________________________________
rem radioterapia, which I immeritately manage, seldom agrees with what I say
marco greco (Catania, Italy) Work:
marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558
(was mar.greco@agora.stm.it) Achea 39 95 503117
--- On 2 Oct 1996 09:47:54 -0500 Jason Wickline
<jwicklin@abel.richland.cc.il.us> wrote:
I am unsure why I am getting different results from the following:
select id
from a
where id not in (select id
from b)
and
select a.id, b.id name
from a, outer b
where a.id = b.id
the count of the null name is not equal to the count of id in first
sql.
Please mail me direct with any help thankyou in advance
jwicklin@richland.cc.il.us
.
-----------------End of Original Message-----------------