Question: https://oj.leetcode.com/problems/combine-two-tables/
Question Name: Combine Two Tables
This problem is used to check our knowledge in JOIN. LEFT JOIN is used here. But we should also know about the others like INNER JOIN, RIGHT JOIN and OUTER JOIN.
1 2 3 4 | # Write your MySQL query statement below SELECT FirstName, LastName, City, State FROM Person LEFT JOIN Address ON Person.PersonId = Address.PersonId |