update tbl set yue=vt.js-vt.ds from
(
select a.id,sum(b.jie) as js,sum(b.dai) as ds
from tbl a,tbl b
where b.date<=a.date group by a.id
)as vt where vt.id=tbl.id