我的第三行哪里錯(cuò)了求大神解答
?
mysql> SELECT goods_id,goods_name,cate_name,brand_name,goods_price FROM tdb_good
s AS g
? ? -> INNER JOIN tdb_goods_cates AS c ON g.cate_id = c.CATE_id,
? ? -> INNER JOIN tdb_goods_brands AS b ON g.brand_id = b.brand_id;
ERROR 1064 (42000): 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 'INNER
?JOIN tdb_goods_brands AS b ON g.brand_id = b.brand_id' at line 3
2015-07-04
?INNER JOIN tdb_goods_cates AS c ON g.cate_id = c.CATE_id,
這里不要逗號(hào)分隔的~