0175-CombineTwoTables.sql

/* Write your T-SQL 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