报表导出1

select s.`salesman_name`,p.`product_type`,ms.`num1`
from `all_head_product` ps
inner join `product_sales` ms on ms.`bill_num` = ps.`bill_num`
inner join `salesman` s on ps.`saleman_id` = s.`salesman_id`
inner join `product` p on ms.`product_id` = p.`pliers_id`
where p.`judge` > 15000