select t1.fbillnum,
       t1.tcustomer_receptid,
       t1.tcustomerid,
       t1.fname,--姓名
       t1.fphonenumber,--客户手机
       t1.fcommunity,--小区名称
       t1.fnumber,--幢/单元/室
       t1.frenovationplandate, --计划装修时间
       t1.fdate,--下单日期
       t1.fnotes,--订单备注
       t1.finstalldate,--安装日期
       t1.forderamount,--成交金额
       t1.freceivedamount,--已收尾款
       t2.fsignetvalue1,
       t2.fsignetvalue2,
       t2.fagentname,
       t2.fphonenumber as fagentphonenumber
from tcustomer_reception t1
         left join tagents t2 on t1.siteid = t2.siteid and t1.tagentsid = t2.tagentsid
where t1.siteid =$siteid$ and t1.tagentsid=$tagentsid$ and t1.tcustomer_receptid=$tcustomer_receptid$