MYSQL | LEFT JOIN
\nSELECT P.FIRSTNAME, P.LASTNAME, A.CITY, A.STATE\nFROM PERSON P LEFT JOIN ADDRESS A\nON P.PERSONID = A.PERSONID\n\n\nPLEASE UPVOTE.
```\nSELECT P.FIRSTNAME, P.LASTNAME, A.CITY, A.STATE\nFROM PERSON P LEFT JOIN ADDRESS A\nON P.PERSONID = A.PERSONID\n\n```\nPLEASE **UPVOTE**.
[]