🌟 Simplified PostgreSQL solution with USING
\n# Code\n\nSELECT firstName, lastName, city, state\nFROM Person\nLEFT JOIN Address\nUSING (personId);\n\n\nIf it was useful don\'t hesitate to upvote \uD83C\uD
\n# Code\n```\nSELECT firstName, lastName, city, state\nFROM Person\nLEFT JOIN Address\nUSING (personId);\n```\n\nIf it was useful don\'t hesitate to upvote \uD83C\uDF20 Or keep it in favorite \uD83C\uDF1F\n![Upvote invitation](https://github.com/MathieuSoysal/CROUS-assistant-Collector/assets/43273304/b801cf95-dcda-4733-ada2-939f5fcb29e0)
['PostgreSQL']