mysql语句prestashop错误 "checkedFrom"

Question

在 prestashop 中，我想为我想要的导出行创建一个新的 SQL 语句。这是我的代码:

  SELECT    nx7k_orders.reference
       , nx7k_orders.date_add
       , nx7k_order_detail.product_name
       , nx7k_order_detail.product_quantity
       , nx7k_customer.firstname
       , nx7k_customer.lastname
  FROM  nx7k_orders
  JOIN  nx7k_order_detail
        ON nx7k_order_detail.id_order = nx7k_orders.id_order
  JOIN  nx7k_customer
        ON nx7k_customer.id_shop = nx7k_order_detail.id_shop

但是，当我单击保存按钮时，顶部显示错误“checkedFrom”

Answer 1

我认为只有当您为表提供别名时才有效:

SELECT no.reference, 
   no.date_add, 
   nod.product_name, 
   nod.product_quantity, 
   nc.firstname, 
   nc.lastname 
FROM   nx7k_orders no 
   JOIN nx7k_order_detail nod 
     ON nod.id_order = no.id_order 
   JOIN nx7k_customer nc 
     ON nc.id_shop = nod.id_shop