We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
$sql = "SELECT customer_info.id AS customer_info_id, customer_info.customer_number AS customer_number, sales_info.id AS sales_info_id, sales_info.custname AS custname, sales_info.xtndprce AS xtndprce, sales_info.docdate AS docate ". "FROM customer_info ". "LEFT JOIN sales_info AS sales_info ON sales_info.custnmbr = customer_info.customer_number WHERE customer_info.customersalespersonid ='$emp_id' AND sales_info.docdate > '$four_months' GROUP by customer_number";