mysql两个表判断是否更新某值

MySQL:
update Table2 inner join Table1 on Table2.C2=Table1.C1 set Table2.B=Table1.A

mysql已校验
比如
update users_dollar inner join users on users_dollar.userId=users.id set users_dollar.dollars='10000',users.lastCheckInTimeStamp='9999' where users.id='debb598a-861c-4d51-90af-0365f2674e43'