Combine Two Tables
來源：程序員人生 發布時間：2015-06-23 08:40:29 閱讀次數：3338次
Table: Person
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| PersonId | int |
| FirstName | varchar |
| LastName | varchar |
+-------------+---------+
PersonId is the primary key column for this table.
Table: Address
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| AddressId | int |
| PersonId | int |
| City | varchar |
| State | varchar |
+-------------+---------+
AddressId is the primary key column for this table.
Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:
FirstName, LastName, City, State
# Write your MySQL query statement below
#分析，由于不管addressid是不是存在，都要打印，所以是左外連接
select p.firstname,p.lastname,a.city,a.state from Person p left outer join Address a on p.personid=a.personid;
select p.firstname,p.lastname,a.city,a.state from Person p left outer join Address a using(personid);
這兩條語句都是可以的
USING "知道" personid 字段在兩個表中都有，所以沒有指定確切的表都沒關系，兩個值必須1致就是。
ON 就沒那末智能，你必須指明要關聯的表和字段名。
生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
