Yes, sorry, a typo, the 'or' should be an 'and'.

Colin

-----Original Message-----
From: Paul Vinkenoog [mailto:paul@...]
Sent: Wednesday, 30 July 2003 10:14 p.m.
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Query tuning help


Hi Colin,

Maybe they were just typos, but I've seen this OR clause several times
now in this thread:

>> But what I want is:
>> Where (((Table1.ForeignKey2 >= 962) or (Table1.ForiegnKey2 <= 973))

Don't you mean AND here? I.e.
(Table1.ForeignKey2 between 962 and 973)
?

Because the OR version, afaict, is the same as
(Table1.ForeignKey2 is not null)

Did you use the OR version for testing?


Greetings,
Paul Vinkenoog



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################