select t1.fprodname,SUM(t1.fqty)fqty,SUM(t1.famount)famount from tcustomer_order t1
inner join tcustomer_reception t2  on t1.siteid=t2.siteid and t1.tagentsid=t2.tagentsid and t1.tcustomer_receptid=t2.tcustomer_receptid
where t1.siteid=$siteid$ and t1.tagentsid=$tagentsid$ and
convert(varchar(7),t2.fdate,120)>=$fbegmonth$ and convert(varchar(7),t2.fdate,120)<=$fendmonth$
group by t1.fprodname order by SUM(t1.fqty) desc