mysql多表更新

UPDATE clue INNER JOIN sys_node ON clue.id=sys_node.rel_id AND sys_node.wf_name='clue'
SET clue.`status`=1,clue.node_name='线索分配',clue.node_time=sys_node.create_time,clue.node_processor=sys_node.create_user_name 
WHERE clue.id=@clue_id AND sys_node.name='线索分配';