Sum of table Moved

Question

question

zohan asked Apr 28, '14

Sum of table Moved

Helo i have this Q> Gold_Cest .................. .Membe_id . Gold . .................. .John . 5 . .................. .Yvan . 10 . .................. .Sam . 100 . .................. Castle_Data ...................................................... ............... .Membe_id | Ocupy| Date | Cest | .....................................................................| .Event | 1 | 24/04/2014 12:00| Sum(*) of Gold_Cest Table Gold | ...................................................................... So wat i want the sum of Gold cest table gold moved in Castle_Data table Cest

table sum move

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Apr 28, 2014 at 06:45 PM

Forgive me as I don't quite understand the question. You are looking for a way to sum the amount of gold (from the Gold_Cest table) for each member in the Castle_Data table? IE: For the .Event member you want the total amount of gold?

0 ·

Answer 1 · 2014-04-29T03:32:29Z

Squirrel answered Apr 29, '14

This is what you want ? INSERT INTO Castle_Data (Membe_id, Ocupy, Date, Cest) SELECT 'Event', 1, '2014-04-24 12:00', SUM(Gold) FROM Gold_Cest

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

zohan commented · Apr 29, 2014 at 08:32 PM

and if i dont want to insert any information to other ids i will set like this Insert intro Castle_data (Cest) Select Sum(gold) From Gold_Cest

0 ·

zohan commented · May 04, 2014 at 09:10 PM

and then delete all the info behind so Insert intro Castle_data (Cest) Select Sumsqasa(gold) From Gold_Cest Set Gold = 0 from Gold_Chest

0 ·

Squirrel commented · May 05, 2014 at 03:23 AM

Begin Trans Insert intro Castle_data (Cest) Select Sum(gold) From Gold_Cest Update Gold_Chest Set Gold = 0 Commit Trans

0 ·

question