THANK YOU this completes what I need to do on my web site.
Here's my final sql coding. I just change my filter to the product code I want to report:
SELECT DATE_FORMAT(DATE( FROM_UNIXTIME(jml_hikashop_order.order_created) ), '%m-%d-%Y' ) AS 'Order Date', jml_hikashop_order.order_status as 'Status', jml_hikashop_order.order_number as 'Order #',
jml_hikashop_address.address_firstname as 'First Name', jml_hikashop_address.address_lastname as 'Last Name', jml_hikashop_address.address_telephone as 'Phone',
jml_hikashop_order.order_payment_method as 'Payment Method', Round(jml_hikashop_order_product.order_product_price,2) as 'Item Price', jml_hikashop_order_product.order_product_quantity as 'Qty', jml_hikashop_order_product.order_product_name as 'Item', jml_hikashop_order_product.order_product_options as 'Options'
FROM jml_hikashop_address
JOIN jml_hikashop_order
ON
(jml_hikashop_address.address_user_id=jml_hikashop_order.order_user_id)
JOIN jml_hikashop_order_product
ON jml_hikashop_order.order_id=jml_hikashop_order_product.order_id
WHERE jml_hikashop_order_product.order_product_name LIKE '%Member'
ORDER BY jml_hikashop_address.address_lastname DESC