At 12:30 PM 26-03-02 +0100, you wrote:

>Thanks for all the hints but I fear none of it worked.

Try these statements (with superfluous brackets removed and correlated
subquery using aliases :

Select (Sum(o.Menge*o.Preis)+Sum(o.Versicherungspreis)) as summe
from Orderd o
where o.Linknummer=12345
and o.retoure=1
and NOT (EXISTS (Select 1 from Rueckzaehler r
where r.Ordernummer=12345 and r.Zaehler=o.Zaehler))

Select Sum(Menge*Preis) + Sum(Versicherungspreis) as summe
from Orderd
where Linknummer=12345 and retoure=1

Did you create this database using a tool that enforces quoted
identifiers? If yes, then your column identifiers will be case-sensitive.

regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com