select t2.fprodnum,
       t1.fprodname,
       t1.fqty,
       t1.fprice,
       t1.famount
from tcustomer_order t1
         left join tagents_product t2 on t1.siteid = t2.siteid and t1.tagentsid = t2.tagentsid and
                                         t1.tagents_productid = t2.tagents_productid
where t1.siteid =$siteid$
  and t1.tagentsid=$tagentsid$
  and t1.tcustomerid=$tcustomerid$
  and t1.tcustomer_receptid=$tcustomer_receptid$