题目描述:
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:
中文理解:写一段sql,将Address信息join到person表后,使用left join方式
代码(sql):
select FirstName,LastName,City,State
from Person t1
left join
(
select PersonId,City,State
from Address
) t2
on t1.PersonId=t2.PersonId;