update pro_traininfo t set t.totalmoney = (select a.price * t.totaltime from gen_makepriceinfo a where a.studentcode = t.studentcode and a.examcode=t.examcode)
WHERE t.studentcode in (
select studentcode from pro_traininfo where studentcode in ('xy01563262','xy01563519')
)
WHERE t.studentcode in (
select studentcode from pro_traininfo where studentcode in ('xy01563262','xy01563519')
)