Created new tables from scratch, entered 100 records. Indexed. Still same problem. The where in the subselect is returning dredeemdat fields that it should not.

>>redeem.dredeemdat is never null, although it can be empty.
>>
>There is absolutely no reason then for the SELECTs behave differently. I would check all involved tables and indexes for corruption.