Easy and Simple solution with explanation
As we want to display first name, last name, city, and state of each person in the Person table. So we use LEFT JOIN here. \n \nThis diagram clears the the all 
As we want to display first name, last name, city, and state of **each person** in the Person table. So we use **LEFT JOIN** here. \n ![image](https://assets.leetcode.com/users/images/18579613-91be-4c19-ae24-c15af1400307_1653331994.4420538.jpeg)\nThis diagram clears the the all doubt, why we are using **LEFT JOIN** as we want **each** person of person table.\n```\n# Write your MySQL query statement below\nSELECT Person.firstName, Person.lastName, Address.city, Address.state\n    FROM Person LEFT JOIN Address \n        ON Person.personId = Address.personId;\n```\n\nRuntime: 403 ms, faster than 51.73% of MySQL online submissions for Combine Two Tables.\nMemory Usage: 0B, less than **100.00%** of MySQL online submissions for Combine Two Tables.\n\n**Happy Coding** \uD83D\uDE0A!!!\nIf you get value from this, then show some love by ***upvoting*** it !!
[]