Hi,

> Now just one last question.....
>
> Adding a
>
> HAVING
> SUM( VARER_DETAIL.ANTALSTK )<>0
>
> Does that have influense on the performance ?

Very little, because the comparison is handled after the aggregation.
The only thing that could make a performance difference is the network
traffic. If this will exclude a lot of records from the final result-set it
will "cheaper" to transfer over the wire.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info