这个语句出错的原因是最后一行的末尾多了一个中文分号。正确的语句如下:

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;

SQL 语句错误:多余的分号导致查询失败

原文地址: https://www.cveoy.top/t/topic/nlZ7 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录