SELECT FirstName, LastName, City, State FROM Person p LEFT JOIN Address a ON p.PersonId = a.PersonId
居然出SQL的题目了，左连接就行
LeetCode SQL: Combine Two Tables
原文：http://www.cnblogs.com/lailailai/p/4243017.html
