> >Do you see DUE_DATE or SERVICE_TAX in the WHERE clase?
> >If not - WHY should an index on these fields be used?
>
> DUE_DATE and SERVICE_TAX are not indexed.

Sorry - I totally misread your post.

> >Well, the WHERE clause isn't exactly an easy one and will be executed
> >for each row in the PTY table... Happy selecting!
>
> Well I know this, but just can't thinkn of anything more simple.
> I must exclude all of the rows in tbl_invalid.
>
> Any sugestions?

Not right now.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."