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 = 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_items
WHERE
pos_customers.id = (SELECT customer_id FROM pos_sales WHERE id = 1741)
AND
pos_sales_items.sale_id = 1741
AND
pos_items.id = pos_sales_items.id
AND
pos_survey_options.id = (SELECT option_id FROM pos_survey_results WHERE sale_id = 1741)
LEFT JOIN
pos_survey_results
ON
pos_survey_results.sale_id = 1741