# Write your MySQL query statement below SELECT p.FirstName, p.LastName, a.City, a.State FROM Person AS p LEFT JOIN Address AS a ON p.PersonId = a.PersonId
考察LEFT JOIN
LeetCode SQL: Combine Two Tables
原文:http://www.cnblogs.com/lailailai/p/4521279.html