175-combine-two-tables

DevGod

Elf Vtuber

Caution

DevGod needs to write an editorial for this problem!

sql

# Write your MySQL query statement below
SELECT Person.firstName, Person.lastName, Address.city, Address.state
FROM Person
LEFT JOIN Address ON Person.personId=Address.personId;