Re: Help... update with sum()

Thank you Jusung and Rauf.
I have cured the problem by creating another table as suggested. I was also missing the neccessary GROUP BY to use the sum() function.

>Any assistance with this problem would be really appreciated.
>Supposing I have a table like this: (Three columns: name, amount,
>total. I shall use commas to separate the fields)
>
>NAME, AMOUNT, TOTAL
>joe, 100,
>joe, 500,
>mary, 200,
>mary, 300,
>jane, 100,
Received on Wed Aug 07 2002 - 19:08:22 CEST