Mysql分类更新数据为同一类的其他数据之和

UPDATE `tab` AS t,(
  SELECT
    bh,
    sum( je ) AS total 
  FROM
    `tab` 
  WHERE
    xm IN ( 'a', 'b', 'c' ) 
  GROUP BY
    bh 
  ) AS n 
  SET t.je = n.total 
WHERE
  t.xm = 'd' 
  AND t.bh = n.bh