mysql 语法错误
敌花师 2015-07-23 09:00:53 INNER JOIN ecs_category g on d.cat_id=g.cat_id where b.shop_id=59 and a.goods_name like '%%' and a.goods_price>=0
Inner Join ecs_brand as e ON e.brand_id = d.brand_id where a.goods_id=d.goods_id
这样写,提示第二行有错,如果这样写,就是说删了第一行后面where的部分就正常了,求原因
INNER JOIN ecs_category g on d.cat_id=g.cat_id
Inner Join ecs_brand as e ON e.brand_id = d.brand_id where a.goods_id=d.goods_id