I have a sql select statement that reads like this.

select allt(c.contactln)+", "+allt(c.contactfn)+" "+c.contactmn as name ,;
sum(o.totalprice) as totalprice;
from customer c, order o ;
where c.id = o.customer ;
into cursor rptCur ;
order by totalprice desc ;
group by name

Can anyone tell me why this is not sorting by descending totalprice order?

Thanks bunch.