泛微OA系统实现流程中将明细表内的多人力字段数据去重之后赋值给主表的多人力字段,我在节点后操作写了一个DML语句,但一直报错,有人知道什么原因吗?
UPDATE formtable_main_8538 a
INNER JOIN (
SELECT MAINID, GROUP_CONCAT(qsr) AS qsr
FROM formtable_main_8538_dt1
WHERE requestid = '{?requestid}'
GROUP BY MAINID
) b ON a.id = b.MAINID
SET a.drl = b.qsr
WHERE a.requestid = '{?requestid}'