Hi again

Why is it, that you put a

|| ''

after the

Varer.Plu_Nr

What effect does this have ?

I have tried without, and it seems just as fastm but with a different
plan.

Actually changing this:

JOIN Varer_Detail ON
((Varer_Detail.VarePlu_ID = Varer.Plu_Nr || '' and
Varer_detail.Afdeling_ID = '001') or
(Varer_Detail.VarePlu_ID = Varer.Plu_Nr || '' and
Varer_detail.Afdeling_ID = '002'))



to this:

JOIN Varer_Detail ON
((Varer_Detail.VarePlu_ID = Varer.Plu_Nr and
Varer_detail.Afdeling_ID IN ('001','002')))


Runs equally fast

Regards

Michael