BiruLyu
6/2/2017 - 4:18 AM

175. Combine Two Tables.sql

# Write your MySQL query statement below

SELECT P.FirstName AS FirstName, P.LastName AS LastName, A.City AS City, A.State AS State
FROM Person AS P LEFT JOIN Address AS A ON A.PersonId = P.PersonId