Skip to content

175. Combine Two Tables 👍

1
2
3
4
5
6
7
8
SELECT
  Person.firstName,
  Person.lastName,
  Address.city,
  Address.state
FROM Person
LEFT JOIN Address
  USING (personId);