Question

运行SQL语句加上order by什么结果都不出来，去掉就查询出来了,

SELECT company_name,store_name,tenant_name,booth_type_name,product_name,category_name,product_price,ROUND(SUM(product_money),2) as sale_money,ROUND(COUNT(product_num),0) as total, MAX(product_money) as max_money,MIN(product_money) as min_money,ROUND(SUM(product_num),2) AS sale_total,product_unit FROM(
SELECT B.company_name,B.tenant_name,B.booth_type_name,B.store_name,A.product_name,A.category_name,A.product_price,A.product_num,A.product_money,A.product_unit
from v_order_item as A LEFT JOIN v_order as B ON B.id= A.order_id WHERE (B.order_status =1 OR (B.order_status=0 AND B.pay_way=5)) AND B.order_from = 2 and B.store_id = 3 AND B.create_time BETWEEN '2019-6-1 00:00:00' AND '2019-7-1 23:59:59'
) a GROUP BY product_name ORDER BY sale_money DESC limit 0, 30

Answer 1

你在 product_name 前面 加上 a.

追问

我这边是有两MySQL数据库，一台运行正常，另外一台加上ORDER BY sale_money DESC 就查询超时，显示不出来结果，去掉就能查的到