#175 Combine Two Tables

https://leetcode.com/problems/combine-two-tables/

MS SQL Server

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