PerrineD Posted December 1, 2020 Share Posted December 1, 2020 Bonjour, Je souhaiterai exporter toutes les commandes ayant un code promo spécifique sur une période. J'ai déjà la requête qui me permet l'export des commandes : SELECT * FROM `ps_order_cart_rule` WHERE `id_cart_rule` = 8 mais je souhaiterai ajouter une date. J'ai effectué plusieurs essais mais impossible de trouver la bonne requête. Je n'y connais pas grand choses en SQL. Si quelqu'un peut m'aider je suis preneuse Merci ! Link to comment Share on other sites More sharing options...
Eolia Posted December 1, 2020 Share Posted December 1, 2020 SELECT * FROM `ps_order_cart_rule` ocr INNER JOIN ps_orders o ON(o.id_order = ocr.id_order) WHERE ocr.`id_cart_rule` = 8 AND o.date_add > "2020-11-01" AND o.date_add < "2020-12-01" Link to comment Share on other sites More sharing options...
PerrineD Posted December 1, 2020 Author Share Posted December 1, 2020 Merci !!!!! 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