Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

kevin

Database select statement

Recommended Posts

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. 0_1539181773908_ps_product.JPG

0_1539181759741_ps_customer table.JPG

I have tried this query:

select pscustomer.firstname, lastname , email from pscustomer inner join psproduct where psproduct.reference in (1800,1898) and psproduct.dateadd >= 2018-05-18

but that gives just all the information of ALL customers back and that's not what i want.

Pleasse help my!

Share this post


Link to post
Share on other sites

Right, what you would have to do is start with the ps order_products table and then work from there. Why not just use an export module at this point.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×