ViSolve DB Team wrote:
> Hi,
>
> Try this..
>
> UPDATE table2 inner join table1 on table2.playedid=table1.playerid
> SET table2.totalscore=sum(table1.score)
>
> Just a guess...
>
> Thanks,
> ViSolve DB Team
>
> ----- Original Message ----- From: "Ravi Kumar." <ravi.kumar@stripped>
> To: <mysql@stripped>
> Sent: Wednesday, December 06, 2006 4:11 PM
> Subject: Update query help
>
>
>> Dear Friends,
>>
>> I have two tables: T1, T2.
>>
>> T1 has 3 columns: playerid, gameid, score
>> T2 has 2 columns: playerid, totalscore.
>>
>> I wish to update table T2 such that sum of T1.score of each player, gets
>> updated in T2.totalscore. It may be something like this:
>>
>> update T2, T1 set T2.totalscore = sum(T1.score) where T1.playerid =
>> T2.playerid
>>
>> OR
>>
>> update T2, T1 set T2.totalscore = sum(T1.score) where T1.playerid =
>> T2.playerid group by playerid
>>
>> However none of the above is working.
>>
>> Where am I wrong? Please help.
>>
>> The version of MySQL I am using is 4.1.14-standard-log.
>>
>> Thanks,
>>
>> Ravi.
>>
>>
>
>
> --------------------------------------------------------------------------------
>
>
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.15.9/573 - Release Date: 12/5/2006
>
ViSolve, I think yo've missed a GROUP BY needed for every Aggregated
function (like SUM) ;-)
