SQL 语句错误:多余的分号导致查询失败
这个语句出错的原因是最后一行的末尾多了一个中文分号。正确的语句如下:
SELECT
gs.id,
gs.goods_name,
gs.title,
gs.model,
gs.sku_no,
p.price,
f.name firstCategoryName,
s.name secondCategoryName,
t.name thirdCategoryName,
gs.main_image,
gs.main_images,
b.NAME brandName,
gs.price
FROM
goods_sku gs ,
(SELECT gp.price FROM goods_price gp LEFT JOIN goods_sku k ON k.id = gp.sku_id WHERE
name = '官网展示价' AND gp.sku_id = k.id ) p
LEFT JOIN goods_category t ON gs.third_category = t.id
LEFT JOIN goods_category s ON s.id = t.pid
LEFT JOIN goods_category f ON s.pid = f.id
LEFT JOIN brand b ON b.id = gs.brand_id
WHERE
gs.del_flag = 0
AND gs.goods_status = 2;
原文地址: https://www.cveoy.top/t/topic/nlZ7 著作权归作者所有。请勿转载和采集!