✅ 100%  EASY || FAST 🔥|| CLEAN SOLUTION 🌟
IF THIS WILL BE HELPFUL TO YOU, PLEASE UPVOTE !\n\n# Code\n\n/* Write your PL/SQL query statement below */\nSELECT p.firstName,\n       p.lastName,\n       a.ci
IF THIS WILL BE HELPFUL TO YOU, PLEASE UPVOTE !\n\n# Code\n```\n/* Write your PL/SQL query statement below */\nSELECT p.firstName,\n       p.lastName,\n       a.city,\n       a.state \nfrom Person p left outer join Address a \non p.personId=a.personId;\n```\nIF THIS WILL BE HELPFUL TO YOU PLEASE UPVOTE \u2705![5kej8w.jpg](https://assets.leetcode.com/users/images/f1e6cb67-cf9a-4ee0-be9d-f1a685709e13_1690464424.995609.jpeg)\n
['Database', 'MySQL', 'Oracle', 'MS SQL Server']