SELECT
concat(first_name,' ',last_name) as Name,
pos_items.item_name as ItemName,
pos_sales_items.item_unit_price as ItemPrice,
pos_sales_items.quantity_purchased as Quantity,
pos_sales.date as DatePurchased,
pos_survey_options.option as Heard,
pos_survey_results.other as Other,
pos_survey_results.recurring as Recurring
FROM
pos_customers,
pos_items,
pos_sales,
pos_sales_items
LEFT JOIN (pos_survey_options,pos_survey_results)
ON
(
pos_survey_results.sale_id = $saleid
AND
pos_survey_options.id = pos_survey_results.option_id
)
WHERE
pos_customers.id = (SELECT customer_id FROM pos_sales WHERE id = $saleid)
AND
pos_sales_items.sale_id = $saleid
AND
pos_items.id = pos_sales_items.item_id
AND
pos_sales.id = $saleid