> For the complete documentation index, see [llms.txt](https://r24zeng.gitbook.io/leetcode-notebook/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://r24zeng.gitbook.io/leetcode-notebook/bu-chong-4060-dao/175.-combine-two-tables-sql.md).

# 175. Combine Two Tables(SQL)

\# Easy

```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>