Two Approach ||  JOIN and UNION || Easy to  understand
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\nMETHOD2 -> UNION\n\nSele
**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\n**METHOD2 -> UNION**\n\nSelect P.firstName, P.lastName,  A.city, A.state From Person P, Address A\n    where P.personId=A.PersonId\nUnion\nSelect P.firstName, P.lastName, null, null From  Person P \n    where p.personId not in (Select personId from Address)\n
['Union Find', 'MySQL']