✅ Simple solution using LEFT JOIN ✅
Intuition\n Describe your first thoughts on how to solve this problem. \n\n# Approach\n Describe your approach to solving the problem. \nUsed LEFT JOIN and adde
# Intuition\n<!-- Describe your first thoughts on how to solve this problem. -->\n\n# Approach\n<!-- Describe your approach to solving the problem. -->\nUsed LEFT JOIN and added the required columns in SELECT statement.\n\n# Code\n```postgresql []\n-- Write your PostgreSQL query statement below\nSELECT \np.firstName,\np.lastName,\na.city,\na.state\nFROM person p\nLEFT JOIN address a\nON p.personId = a.personId\n```
['PostgreSQL']