Edit History

Eolia · November 9, 2019

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

Eolia · November 9, 2019

le Group By doit être en dernier dans ta requête

SELECT
id_order,
total_price_tax_incl,
purchase_supplier_price,
product_quantity
FROM ps_order_detail

LEFT JOIN ps_orders ON ps_order_detail.id_order = ps_orders.id_order

GROUP BY id_order