Bryan White wrote:
>
> This statement works:
> select date, (select sum(qty * price) from orderdetail d where d.orderid =
> orders.orderid) from orders
>
> But when I try to do something like this:
>
> select date, sum(select sum(qty * price) from orderdetail d where d.orderid
> = orders.orderid) from orders group by date
>
> I get ERROR: parser: parse error at or near "select"
>
> Is there a way to apply an agregate function to a subselect like this?
Avoiding the question, I'm wondering if this simpler form wouldn't be
what you're after?
select o.date, sum(d.qty * d.price) from orderdetail d, orders owhere d.orderid = o.orderidgroup by o.date
Regards,
Ed Loehr