| Subject | Re: [IBO] SQL Problens |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2002-04-04T09:11:59Z |
Wonder if this works better if I send it to the correct address?
Set
Set
>Date: Thu, 04 Apr 2002 11:09:40 +0200
>To: ibobjeccts@yahoogroups.com
>From: Svein Erling Tysvær <svein.erling.tysvaer@...>
>Subject: Re: [IBO] SQL Problens
>
>Alcir,
>
>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?
>
>HTH,
>Set