Subject Re: [IBO] SQL Problens
Author Svein Erling Tysvær
Wonder if this works better if I send it to the correct address?


>Date: Thu, 04 Apr 2002 11:09:40 +0200
>From: Svein Erling Tysvær <svein.erling.tysvaer@...>
>Subject: Re: [IBO] SQL Problens
>do you mean that you want something like
>SELECT SUM(b.PrItSale*b.QtItSale-DiscountItSale)-
> (SELECT (SUM(a.DiscountSale) FROM Sale a)
>FROM ItSale b
>to find the total price of all sales?