Re: sql script which doesn't find everything

I'm a beginner with SQL queries and this is driving me crazy.  I've
created the following query:

select number, subscription_duration, po_expiry_date,
subscription_start_date
from handles
where subscription_duration not  like 'F'

 
and po_expiry_date > '1-jan-98'
and subscription_start_date < '1-jan-98'
order by po_expiry_date, maxer_number;

The problem is if I do a query WITHOUT subscription_duration not like
'F', I get a total of 19990 records.

If I do a query with subscription_duration like 'F', I get a total of
412.

So, I should have 19478 records?  Or not???

I hope somebody can help me to sharpen this query!

Thanks in advance for your help!

Sincerely yours,

Sandy.

--
Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV
-------------------------------------------------
Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046
  Received on Mon Apr 12 1999 - 13:06:19 CEST