175. Combine Two Tables mysql

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

 

select s.firstName, s.lastName, a.city, a.state from person s left join address a on s.personId = a.personId;