Jump to content

Pb de SQL Erreur non définie "checkedFrom"

Recommended Posts


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

Link to comment
Share on other sites

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 


Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...