select t1.fname,t1.fprovince,t1.fcity,t1.fcounty,t1.fbegdate,t1.fenddate,t1.fdays,t1.fothername,
t1.fnotes,t1.fgrade,t1.createby,t1.createdate,t1.changedate,t1.tbusinesstripid,t1.tagentsid,t1.fstatus,t2.fagentshortname  from tbusinesstrip t1
left join tagents t2 on t1.siteid=t2.siteid and t1.tagentsid=t2.tagentsid
where t1.siteid=$siteid$  and t1.tbusinesstripid=$tbusinesstripid$