Hello,
I have the following statement... select sum(p.priprice *
o.quantity) as total from products p, ordertemp o where o.orderid='xxxx' and
o.itemid=p.itemid; This statement returns something like $x,xxx.xx.
The column p.priprice is of type money and o.quantity is of type
int4. Is there any way to modify that statement to return something like
xxxx.xx?
Craig Anderson
Director of Internet Services
Netstat Resources, LLC.