对应sql如下:
SELECT wb.id,workflowname, wfb.tablename maintablename, wbf.detailtable, wbf.fieldname, workflowtype,isvalid ,workflowdesc ,islockworkflow
from workflow_base wb
LEFT JOIN workflow_bill wfb on wb.formid = wfb.id
LEFT JOIN workflow_billfield wbf on wb.formid = wbf.billid
WHERE isvalid = 1 AND workflowname like'%需求%'
PS:detailtable为空时对应的字段为主表字段。
809

被折叠的 条评论
为什么被折叠?



