>select customer >scan > select sales > sum ordertotal for sales.customerid = customer.customerid to > nTotalSale > replace customer.totalsales with nTotalSale >endscan >>
select customer.customerid as customerid,sum(sales.ordertotal) as ordertotal ; from ; customer,sales ; where ; sales.customerid = customer.customerid ; into cursor temp group by 1 select temp index on customerid tag cusid select customer replace customer.totalsales with temp.ordertotal ; for seek(customer.customerid,'temp','cusid')suhashegde