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'
多表关联条件update
发布时间 2023-10-12 14:35:23作者: stfzhuang
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'