Need help with a mySQL Query

[jeffmic]

Hey gang,

I'd like to create the following mySQL query from the ZenCart tables, but I'm unable to figure it out.

I want to find ALL products purchased under a specific customer number.

I can get all invoices for a customer number
and all products under an invoice
but I'l like to skip the invoices and just show all the products sold under a specific customer number

Any formulas would be appreciated

thanks,

[DrByte]

select * 
from zen_orders_products 
where orders_id in (
  select orders_id 
  from zen_orders 
  where customers_id = 1
) order by products_name, products_model;

[HeyIts007]

Can you show me how to do such a query ? I would like to make a custom query in a php script.

[DigitalShadow]

Similar to what I'm trying to achieve I think...

I want a page where a customer can at a glance see all products they have purchased.