PatJ Posted March 28, 2019 Share Posted March 28, 2019 Bonjour à tous J'ai préparé une requête dans PHPMyadmin et elle fonctionne. J'obtiens les résultats attendus. Je souhaite l'enregistrer dans le SQL Manager pour plus de facilité d'utilisation mais lorsque j'essaye de l'enregistrer j'obtiens cette erreur: Erreur non définie "checkedSelect" Quelle peut être la raison de ce message ? Voici la requête en question: SELECT ps_customer.id_customer,`id_order`,ps_customer.lastname,ps_customer.firstname,`phone_mobile` FROM `ps_orders`, `ps_customer`,`ps_address` WHERE `delivery_date` BETWEEN CURRENT_DATE() - INTERVAL '7' DAY AND CURRENT_DATE() AND ps_orders.id_customer IN (SELECT ps_orders.id_customer FROM `ps_orders` WHERE `current_state` = 5 GROUP BY `id_customer` HAVING COUNT(`id_order`)=1) AND ps_orders.id_customer = ps_customer.id_customer AND ps_orders.id_customer = ps_address.`id_customer` Merci de vos suggestions. 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