Mysql字段列表错误

SELECT
ps_orders.id_customer,
ps_customer.firstname,
ps_customer.lastname,
ps_customer.email,
ps_orders.total_paid,
ps_orders.date_add,
ps_address.phone_mobile
FROM
ps_orders JOIN ps_customer on  ps_orders.id_customer = ps_customer.id_customer
WHERE ps_address.id_customer=ps_orders.id_customer and
ps_orders.total_paid > 1 
AND ps_orders.id_customer IN (
SELECT
ps_orders.id_customer
FROM
ps_orders
GROUP BY
ps_orders.id_customer
HAVING
COUNT(1) < 2
  )

您需要指定要选择FROM的表。因此，如果该列存在，下面是更新后的查询（缩写）：

SELECT
    ps_orders.id_customer,
    ps_customer.firstname,
    ps_customer.lastname,
    ps_customer.email,
    ps_orders.total_paid,
    ps_orders.date_add,
    ps_address.phone_mobile
FROM
    ps_address, ps_orders
JOIN
   ps_customer on ps_orders.id_customer = ps_customer.id_customer
WHERE
   ps_address.id_customer=ps_orders.id_customer AND
   ps_orders.total_paid > 1 AND 
   ps_orders.id_customer IN (...)

此语法错误意味着，此表中没有此列"phone_mobile""ps_address"。

该列根本不存在？

您的脚本有语法错误。中不存在列名"1"

COUNT（1）<2

必须是：COUNT（column_name）<2.或COUNT（*）<2

---

COUNT（ps_orders.id_customer）<2