LEFT JOIN and Selecting Columns to pull
Intuition\nI need to merge both tables and pull four columns.\n\n# Approach\nI pulled the four columns and joined the data tables using a LEFT JOIN.\n\n# Comple
# Intuition\nI need to merge both tables and pull four columns.\n\n# Approach\nI pulled the four columns and joined the data tables using a LEFT JOIN.\n\n# Complexity\n- Time complexity:\nn/a\n\n- Space complexity:\nn/a\n\n# Code\n```\nSelect Person.firstName,Person.lastName,Address.city,Address.state FROM Person\nLEFT JOIN Address\nOn Person.personId = Address.personId\n\n```
['MySQL']