select c.customer_id,concat(c.customer_fname,' ',c.customer_lname) as fullname, o.order_customer_id,o.order_status from
customers c left outer join orders o on (c.customer_id = o.order_customer_id)
group by o.order_status
您可以尝试以下查询:
select
c.customer_id,
concat(c.customer_fname,' ',c.customer_lname) as fullname,
o.order_customer_id,
o.order_status
from
customers c left outer join orders o on (c.customer_id = o.order_customer_id)
group by c.customer_id,concat(c.customer_fname,' ',c.customer_lname),o.order_customer_id, o.order_status
正如其他堆栈已经建议您在group by
语句中缺少列一样。所有非聚合列都应包含在 group by
中。