MS SQL: LEFT JOIN; ON
\nSELECT\n    firstName,\n    lastName,\n    city,\n    state\nFROM\n    Person AS P\nLEFT JOIN\n    Address AS A\nON\n    P.personId = A.personId\n
```\nSELECT\n    firstName,\n    lastName,\n    city,\n    state\nFROM\n    Person AS P\nLEFT JOIN\n    Address AS A\nON\n    P.personId = A.personId\n```
[]