多表关联条件update

 

A表的update  关联B表的条件。

update a set  khddh ='ceshi'  from formtable_main_291 a  left join workflow_requestbase b on  a.requestid = b.requestid where b.currentnodetype =0 and  a.xsddh = '123'