Will this Query Work infinetly, or it break

[mohammad azharuddin]

update rptprogressiveoutwaneftrpt a inner join (select sum(amount) as balamount ,max(cast(id as unsigned)) as mid from rptprogressiveoutwaneftrpt group by transdate ) b on a.id=b.mid set a.balanceamount=b.balamount where transdate>=?


joining on same table having same date , sum all amount and set to date having max id

will this query work or it has a chance to break, some value may update or some may not ?