第四章 第八节：多表连接

goods表连接goods_cate和goods_brands

SELECT id,name,brand,cate,price FROM goods AS g

INNER JOIN goods_cate AS c ON g.cate = c.cate_name 

INNER JOIN goods_brand AS b ON g.brand = b.brand_name\G;