---
description: '# Easy'
---

# 175. Combine Two Tables(SQL)

```sql
# Write your MySQL query statement below
select FirstName, LastName, City, State from Person
left join Address on Person.PersonId = Address.PersonId;
```

Ref: [https://www.diffen.com/difference/Inner\_Join\_vs\_Outer\_Join](https://www.diffen.com/difference/Inner_Join_vs_Outer_Join)
