表连接,属于外连接的左连接。
# Write your MySQL query statement below
SELECT p.FirstName, p.LastName, a.City, a.State FROM Person p LEFT OUTER JOIN Address a ON p.PersonId = a.PersonId;
表连接,属于外连接的左连接。
# Write your MySQL query statement below
SELECT p.FirstName, p.LastName, a.City, a.State FROM Person p LEFT OUTER JOIN Address a ON p.PersonId = a.PersonId;