多表链接

###内链接

*等值连接
SELECT * 
FROM tabl1,tabl2
WHERE tabl1.table_type=tabl2.id;

*等值特定语法
SELECT *
FROM table1, INNER JOIN table2
ON table1.id=table2.fkid;

*不等值连接
SELECT a.goods_id,agoods_name
FROM table1 a INNER JOIN (SELECT * FROM table2 WHERE name='') b
ON a.id<>b.id

*自然连接
SELECT A


*连接多个表
SELECT a.goods_id,a.goods_name,b.name brand,c.name type
FROM goods a, brand b,goods_type c
WHERE a.brand_id=b.id AND a.goods_type=c.id