SQL EXPERT WANTED !
Posted: Fri Jul 13, 2018 4:58 pm
Weeks ago MarketinSG was nice to tell us
SQL: "emails from customers who bought model ABC"
SELECT email FROM `order` o LEFT JOIN order_product op ON op.order_id = o.order_id WHERE op.model = 'ABC'
The above will get you the emails for customers who purchased product model 'ABC'
Ny next question is
SQL command to extract emails customers who bought model ABC FROM order_id 3.000 to order_id 4.000
3.000 and 4.000 are just example values.
Why? I want to email customers who purchased product say 2 years ago and ask about their experience etc.
Highly appreciated if you know that
Michael, Denmark
SQL: "emails from customers who bought model ABC"
SELECT email FROM `order` o LEFT JOIN order_product op ON op.order_id = o.order_id WHERE op.model = 'ABC'
The above will get you the emails for customers who purchased product model 'ABC'
Ny next question is
SQL command to extract emails customers who bought model ABC FROM order_id 3.000 to order_id 4.000
3.000 and 4.000 are just example values.
Why? I want to email customers who purchased product say 2 years ago and ask about their experience etc.
Highly appreciated if you know that
Michael, Denmark
I have all my orders in folder in thunderbird - thousands - and all my emails display order number and date in the same line, so easy to see dates. Numbers are much easier to work with than dates. It is NOT important with exact dates, just approx how many months ago. I sell water filters and the filters need to be change every 6-12 months and I want to remind my customers about that. I do NOT like recurring products. I want that my customers decide for themselves - respect.