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