# #175 Combine Two Tables

#### [https://leetcode.com/problems/combine-two-tables/](https://leetcode.com/problems/combine-two-tables/)

{% tabs %}
{% tab title="MS SQL Server" %}
```sql
SELECT Person.FirstName, Person.LastName, Address.City, Address.State
FROM Person
LEFT JOIN Address
ON Person.PersonId = Address.PersonId;
```
{% endtab %}
{% endtabs %}
