MySQL UPDATE JOIN 예제

UPDATE
    `money_charge_list` `charge` INNER JOIN
    `member_list` `member`
    ON `charge`.`memberSeqNo` = `member`.`seqNo`
SET
    `charge`.`transactionState` = 'complete',
    `charge`.`processedTime` = NOW(),
    `member`.`currentMoney` = `member`.`currentMoney` + `charge`.`money`
WHERE `charge`.`transactionState` = 'processing'

용동기입장 한번 만들어 보는데 힘들군요!