Subject Re: [ib-support] Sum() on a subselect?
Author Svein Erling Tysvaer
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

Wouldn't

sum(select sum(fc.fifocost*fc.fifoqty) from fifocosts fc where
fc.fifobarcode=A.prodbarcode) as paidcost

yield the same result?

Set