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 = 'SA41150003'
AND a.temp_id = '10002'
AND b.node_itm = 4
ORDER BY b.sh_dd DESC;
最后修改:2024 年 01 月 18 日
© 允许规范转载