kevin Posted October 10, 2018 Share Posted October 10, 2018 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 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! Link to comment Share on other sites More sharing options...
DaoKakao Posted October 10, 2018 Share Posted October 10, 2018 Hmmm... I don't think a customer have any kind of link with any product except thru the order. Link to comment Share on other sites More sharing options...
lesley Posted October 10, 2018 Share Posted October 10, 2018 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. Link to comment Share on other sites More sharing options...
musicmaster Posted October 10, 2018 Share Posted October 10, 2018 Sorry to make a correction. It is the psorderdetail table (or tborderdetail). Link to comment Share on other sites More sharing options...
lesley Posted October 10, 2018 Share Posted October 10, 2018 Ahh true. Sorry about that. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now