[thelist] SQL 2000 update statement - thanks

[Ingrid Z]

Thanks Rudy and Paul,

Rudy, your suggestion has helped. All I have to do now is re-sort the order
before I dump into the text file, so the order total column appears with the
orders for that user.
The shopping cart will be re-structured anyway, this is an interim solution.


Thanks very much,
Ingrid

> if not, try
>
>   insert into summary (custname, ordertotal)
>     select custname, sum(orderamt)
>   from orders
>      group by custname
>
> rudy
> http://lists.evolt.org Workers of the Web, evolt !
>