The thing that i need is the, Firstname, Lastname and Email of the customer who purchased the product with reference 1800 and 1898. before 2018-05-18.
I have tried this query:
select ps_customer.firstname, lastname , email from ps_customer inner join ps_product where ps_product.reference in (1800,1898) and ps_product.date_add >= 2018-05-18
but that gives just all the information of ALL customers back and that's not what i want.
Pleasse help my!