MYSQL: update tables from other tables

INSERT INTO stat (date, id, v, c, r)

SELECT date, id, sum(v), sum(c), sum(r) FROM stat2

group by date, id ;

update stat s, (SELECT date(datetime) as date, id,

sum(IF(status='good', value, 0)) as v_g, sum(IF(status='good', 1, 0)) as c_a,

sum(IF(status='bad', value, 0)) as v_b, sum(IF(status='bad', 1, 0)) as c_p

FROM stat2

group by id, date) as t

SET s.good = t.v_g, s.good_count = t.c_a, 

s.bad = t.v_b, s.bad_count = t.c_p

WHERE s.date = t.date AND t.id = s.id;