Hi SET,

> 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

SUM() has brackets and a sub-select must also have brackets (see
SQL-standard) and then you end up by two brackets ;-)

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81