bwj_server/src/dsb/com/cnd3b/restcontroller/enterprise/supplyanddemand/SQL/供需详情查询.sql

select t1.tsupplyanddemandid, t1.ftitle,t1.fissupply,
       t1.ftype, t1.fstatus, t1.checkby, t1.checkdate,
       t1.fenddate,t1.tcooperationagentsid,t2.fagentname,t3.fname,t3.fphonenumber,
       t4.fagentname as fcooperationagentname,10 as fcommunicationtimes,t1.fcontent,t1.tenterprise_userid
from tsupplyanddemand t1
inner join tagents t2 on t1.siteid=t2.siteid and t1.tagentsid=t2.tagentsid
inner join tenterprise_users t3 on t1.siteid=t3.siteid and t1.tenterprise_userid=t3.tenterprise_userid
left join tagents t4 on t1.siteid=t4.siteid and t1.tcooperationagentsid=t4.tagentsid
where t1.siteid=$siteid$ and t1.tagentsid=$tagentsid$ and tsupplyanddemandid=$tsupplyanddemandid$