sql.append(" select t3.factdefname_l2,t2.fname_l2 person,t.fispass,t.fopinion_l2,t.fcreatetime "); sql.append(" from T_BAS_MultiApprove t "); sql.append(" inner join t_pm_user t2 on t2.fid=t.fcreatorid "); sql.append(" left join T_WFR_AssignDetail t3 on t3.FASSIGNID=t.FASSIGNMENTID "); sql.append(" where t.fbillId = ‘").append(pk.toString()).append("‘ AND fstatus = 1 "); sql.append(" order by t.fCREATETIME desc");
select t3.factdefname_l2,t2.fname_l2 person,t.fispass,t.fopinion_l2,t.fcreatetime from T_BAS_MultiApprove t inner join t_pm_user t2 on t2.fid=t.fcreatorid left join T_WFR_AssignDetail t3 on t3.FASSIGNID=t.FASSIGNMENTID where t.fbillId = ‘YZoAAABDd3SarJDl‘ AND fstatus = 1 order by t.fCREATETIME desc
原文:https://www.cnblogs.com/duomi/p/14716290.html