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.


  • Content Count

  • Joined

  • Last visited

Posts posted by kevin

  1. 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!

  • Create New...