Dumb Oracle Question

From: Mtek <mtek_at_mtekusa.com>
Date: Wed, 4 Jun 2008 15:16:54 -0700 (PDT)
Message-ID: <f3d5d36b-1d82-465f-bd97-0ccd650f6133@b1g2000hsg.googlegroups.com>


Hi,

Aren't these statements supposed to be equal??

select cust_no from customer where z_rank_d = 1 minus
select cust_no from customer_rank1;

select cust_no from customer where z_rank_d = 1   and not exists
(select cust_no from customer_rank1);

What am I missing? The first returns 27 rows, the second, nothing.......

John Received on Wed Jun 04 2008 - 17:16:54 CDT

Original text of this message