Subject | Re: [ib-support] Sum() on a subselect? |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-05-26T11:35:08Z |
Arno, it is wonderful to see all the additional stuff I will get access to
once we switch to Fb 1.5. But why would you need double brackets in the
statement
At 12:58 26.05.2003 +0200, you wrote:
sum(select sum(fc.fifocost*fc.fifoqty) from fifocosts fc where
fc.fifobarcode=A.prodbarcode) as paidcost
yield the same result?
Set
once we switch to Fb 1.5. But why would you need double brackets in the
statement
At 12:58 26.05.2003 +0200, you wrote:
> sum((select sum(fc.fifocost*fc.fifoqty) from fifocosts fc whereWouldn't
>fc.fifobarcode=A.prodbarcode)) as paidcost
sum(select sum(fc.fifocost*fc.fifoqty) from fifocosts fc where
fc.fifobarcode=A.prodbarcode) as paidcost
yield the same result?
Set