update members as mem
  set mem.exp_istree = (
      select mov.total*mov.price from moves as mov
      where mov.member_ndx = mem.id
      group by mov.member_ndx
  )

CREATE TABLE `members` (
  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Sum1` decimal(11,2) DEFAULT NULL,
  `Sum2` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`Id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `moves` (
  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DATE` date NOT NULL,
  `Member_Ndx` int(10) unsigned NOT NULL,
  `Total` decimal(11,3) DEFAULT '0.000',
  `Price1` decimal(11,2) DEFAULT '0.00',
  `Price2` decimal(11,2) DEFAULT '0.00',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `MemCard_Key` (`Member_Ndx`,`DATE`,`Id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

UPDATE members AS mem
  SET mem.sum1 = (
      SELECT SUM(mov.total*mov.price1) FROM moves AS mov
      WHERE mov.member_ndx = mem.id
      GROUP BY mov.member_ndx
  )

UPDATE members AS mem
  SET mem.sum1, mem.sum2 = (
      SELECT SUM(mov.total*mov.price1), SUM(mov.total*mov.price2) FROM moves AS mov
      WHERE mov.member_ndx = mem.id
      GROUP BY mov.member_ndx
  )

UPDATE members AS mem,
  (
      SELECT
        mov.member_ndx
      , SUM(mov.total*mov.price1) sum1
      , SUM(mov.total*mov.price2) sum2
      FROM moves AS mov
      WHERE mov.member_ndx = 1001
      GROUP BY mov.member_ndx
  ) sq
SET
  mem.sum1 = sq.sum1, mem.sum2 = sq.sum2
WHERE 
  (mem.id = 1001) AND (sq.member_ndx = mem.id)