- inner join(内连接)
在左表 (table_name1) 中存在至少一个匹配时返回行。如果没有匹配,就不会列出这些行
- left join(左联接)
从左表 (table_name1) 那里返回所有的行,即使在右表 (table_name2) 中没有匹配的行
- right join(右联接)
从右表 (table_name2) 那里返回所有的行,即使在左表 (table_name1) 中没有匹配的行
Inner Join 语法:
SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name
Left Join 语法:
SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2
ON table_name1.column_name=table_name2.column_name
Right Join 语法:
SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name=table_name2.column_name
三个数据表的用法
SELECT column_name(s)
FROM (table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name)
INNER JOIN table_name3 ON table_name1.column_name=table_name3.column_name