无法执行,出现错误,检查不出来错在哪里
select * from (ecm_order_goods left join ecm_goods on ecm_order_goods.goods_id = ecm_goods.goods_id where ecm_order_goods.order_id=16) a left join `ecm_gcategory` b on a.cate_id=b.cate_id
select * from (ecm_order_goods left join ecm_goods on ecm_order_goods.goods_id = ecm_goods.goods_id where ecm_order_goods.order_id=16) a left join `ecm_gcategory` b on a.cate_id=b.cate_id
提示是:#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where ecm_order_goods.order_id=16) a left join `ecm_gcategory` b on a.cate_id=b.' at line 1
(ecm_order_goods left join ecm_goods on ecm_order_goods.goods_id = ecm_goods.goods_id
whereand ecm_order_goods.order_id=16) aleft join `ecm_gcategory` b on a.cate_id=b.cate_id
left join ecm_goods on ecm_order_goods.goods_id = ecm_goods.goods_id
left join `ecm_gcategory` on ecm_gcategory.cate_id = ecm_order_goods.cate_id//我不确定cate_id是不是ecm_order_goods这张表里的
where ecm_order_goods.order_id=16