SELECT c.name, b.sh_dd, d.photo_pic
FROM wf_flow_inst a
LEFT JOIN wf_flow_d b ON a.inst_id = b.inst_id
LEFT JOIN tbrsystem..pswd c ON b.sh_usr = c.usr
LEFT JOIN salm d ON d.sal_no = b.sh_usr
WHERE a.bil_no ='SA5B270006'
AND A.BIL_ID='SA'
AND b.node_itm =2
ORDER BY b.sh_dd DESC;
最后修改:2025 年 12 月 04 日
© 允许规范转载