十二.连接的语法结构

1.内连接

2.左连接

 

 3.右连接

4.多表连接

SELECT goods_id,goods_name,cate_name,brand_name,goods_price FROM tdb_goods AS g INNER JOIN tdb_goods_cates AS c ON g.cate_id = c.cate_id ->INNER JOIN tdb_brands AS b ON g.brand_id = b.brand_id\G;

 

转载于:https://www.cnblogs.com/chenshaoping/p/8830886.html