MySQL SHORTEST Solution (ONE LINE 🔥🔥)
Please UPVOTE \uD83D\uDD25\n\nSELECT firstName,lastName, city , state FROM Person LEFT JOIN Address ON Person.personID = Address.personID \n\n\n\n Another  solu
***Please UPVOTE \uD83D\uDD25***\n```\nSELECT firstName,lastName, city , state FROM Person LEFT JOIN Address ON Person.personID = Address.personID \n\n```\n\n*  **Another  solution**  (*just to see the differenc*e)\n\n```\nSELECT \n\tfirstName,\n    lastName, \n    (CASE WHEN \n        (SELECT city FROM Address WHERE Address.personID =  Person.personID)IS NULL \n\t\tTHEN NULL \n\t\tELSE (SELECT city FROM Address WHERE Address.personID = Person.personID) \n\t\tEND)AS city ,\n    (CASE WHEN \n        (SELECT state FROM Address WHERE Address.personID = Person.personID)IS NULL \n\t\tTHEN NULL \n\t\tELSE  (SELECT state FROM Address WHERE Address.personID = Person.personID) \n\t\tEND) AS state\nFROM Person \n```\n***Please UPVOTE \uD83D\uDD25***
['MySQL']