MySQL || Easy || Left Join || Combine two tables
\nSELECT person.firstname, person.lastname, address.city, address.state \nFROM person \nLEFT OUTER JOIN address \nON person.personid = address.personid;\n\nPlea
```\nSELECT person.firstname, person.lastname, address.city, address.state \nFROM person \nLEFT OUTER JOIN address \nON person.personid = address.personid;\n```\nPlease **UpVote**, if you understood the problem.
['MySQL']