SQL Schema

Table: Person

+-------------+---------+ 
| Column Name | Type    | 
+-------------+---------+ 
| PersonId    | int     | 
| FirstName   | varchar | 
| LastName    | varchar | 
+-------------+---------+ 
PersonId is the primary key column for this table. 

Table: Address

+-------------+---------+ 
| Column Name | Type    | 
+-------------+---------+ 
| AddressId   | int     | 
| PersonId    | int     | 
| City        | varchar | 
| State       | varchar | 
+-------------+---------+ 
AddressId is the primary key column for this table. 

Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:

FirstName, LastName, City, State

Idea – 1

We need to join Person and Address tables. Inner Join gives results when both tables have matching PersonId. We need to return result even if a person does not have address information. So, we use Left Join – if a person does not have address information we only get first and last names.

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


Runtime: 203 ms, faster than 95.92% of MySQL online submissions for Combine Two Tables.