INNER JOIN 在表中存在至少一个匹配时,INNER JOIN 关键字返回行。
SELECT table1.column1, table2.column2…
FROM table1
INNER JOIN table2 ON table1.column_name = table2.column_name;
LEFT JOIN 关键字会从左表 (table_name1) 那里返回所有的行,即使在右表 (table_name2) 中没有匹配的行
SELECT table1.column1, table2.column2…
FROM table1
LEFT JOIN table2 ON table1.column_name = table2.column_name;
SELECT table1.column1, table2.column2…
FROM table1
RIGHT JOIN table2 ON table1.column_name = table2.column_name;
示例学习
也可以用另一种方法,返回一样的结果
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons, Orders
WHERE Persons.Id_P = Orders.Id_P
ORDER BY Persons.LastName