⭐Two Methods By JOIN and UNION⭐
\uD83D\uDE0ADO UPVOTE IF YOU FIND HELPFUL \uD83D\uDE0A\n\nMETHOD -> JOIN\n\nSELECT p.firstName, p.lastName, a.city, a.state \nFROM Person p left join Address a\
*\uD83D\uDE0ADO UPVOTE IF YOU FIND HELPFUL \uD83D\uDE0A*\n\n**METHOD -> JOIN**\n```\nSELECT p.firstName, p.lastName, a.city, a.state \nFROM Person p left join Address a\nON p.personId = a.personId;\n```\n**METHOD2 -> UNION**\n```\nSELECT p.firstName, p.lastName, a.city, a.state from Person p, Address a\nWHERE p.personId = a.personId\nUNION\nSELECT  p.firstName, p.lastName, null, null from Person p\nWHERE p.personId NOT IN (Select personId from Address);\n```
['Union Find', 'MySQL']