mysql如何用左连接去更新2张表的数据

需求是：我想同时2个表的state=1,tapp_tabdealinfo的appdeal_id和tapp_joblist的joblist_dealid是外键。

更新条件是joblist_state = 20并且joblist_owner 是指定的名字。

SET @jobOwner = 'zhangjingjing';
UPDATE
tapp_joblist job
LEFT JOIN
tapp_tabdealinfo deal
ON
job.joblist_dealid = deal.appdeal_id
SET
appdeal_state = 1,joblist_state = 1
WHERE job.joblist_state = 20
AND job.joblist_owner = @jobOwner

我刚做的小程序哦，欢迎交流程序问题哦～