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,