175_Combine_Two_Tables.sql

SELECT
  p.FirstName
  ,p.LastName
  ,a.City
  ,a.State
FROM
  Person AS p
LEFT JOIN
  Address AS a
ON p.PersonId = a.PersonId;