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

That's it! Thanks everybody for the help. This has already cost me 2 days!
regards
Jan Turner

""Helen Borrie (TeamIBO)"" <helebor@...> schrieb im Newsbeitrag
news:5.1.0.14.0.20020326224808.068f8a70@......

> 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
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>