[email protected] Posted November 9, 2019 Share Posted November 9, 2019 Hello la communauté, Je suis confronté à une erreur dans ma requête SQL (voir ci-dessous) L'objectif de cette requête est de me lister l'ensemble des commandes (id_order) avec en face : prix vente + prix d'achat + quantité + date. Ma requête fonctionne très bien jusqu'a ce que je fasse le left join pour récupérer les dates des commandes Pouvez-vous m'aider ? Merci par avance ##### SELECT id_order, total_price_tax_incl, purchase_supplier_price, product_quantity FROM ps_order_detail GROUP BY id_order LEFT JOIN ps_orders ON ps_order_detail.id_order = ps_orders.id_order Link to comment Share on other sites More sharing options...
Eolia Posted November 9, 2019 Share Posted November 9, 2019 (edited) le Group By doit être en dernier dans ta requête et il manque des alias SELECT od.id_order, od.total_price_tax_incl, od.purchase_supplier_price, od.product_quantity FROM ps_order_detail od LEFT JOIN ps_orders o ON od.id_order = o.id_order GROUP BY od.id_order Edited November 9, 2019 by Eolia (see edit history) Link to comment Share on other sites More sharing options...
[email protected] Posted November 9, 2019 Author Share Posted November 9, 2019 Ca fonctionne 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