Solution of combine two tables problem
Approach\n- The LEFT JOIN keyword returns all records from the left table (Person), and the matching records from the right table (Adress). The result is 0 reco
# Approach\n- The `LEFT JOIN` keyword returns all records from the left table ($$Person$$), and the matching records from the right table ($$Adress$$). The result is 0 records from the right side, if there is no match.\n# Code\n```\nSELECT firstName, lastName, city, state\nFROM Person \nLEFT JOIN Address ON Person.personId = Address.personId;\n\n```
['Database', 'MySQL']