Pb de SQL Erreur non définie "checkedFrom"

[gregory.dufour@vd-ag]

 

Bonjour j'ai un soucis avec une requette SQL 

 

je n'arrive pas a faire fonctionner cette requete 

quelqu'un peut il m'aider 

select  id_order, product_name, total_price_tax_incl, total_price_tax_excl, ps_orders.invoice_date, ps_orders.total_paid_tax_incl, ps_orders.total_paid_tax_excl
from ps_orders INNER JOIN ps_order_detail ON (ps_order_detail.id_order = ps_orders.id_order)
Where invoice_date BETWEEN '2018-01-01' AND '2018-05-31' 
GROUP BY ps_orders.id_order

[phinq1910]

This is basic sql. Just define name for table (from) and table join and use that. E.g.

select  od.id_order, od.product_name, od.total_price_tax_incl, od.total_price_tax_excl, o.invoice_date, o.total_paid_tax_incl, o.total_paid_tax_excl
from ps_orders o
	INNER JOIN ps_order_detail od ON (o.id_order = od.id_order)
Where od.invoice_date BETWEEN '2018-01-01' AND '2018-05-31' 
GROUP BY o.id_order