SQL SERVER - Basic Join
\n\n# Code\n\nselect firstname,lastname,city,state\nfrom person\nleft join address\non person.personId=address.personId\n\n
\n\n# Code\n```\nselect firstname,lastname,city,state\nfrom person\nleft join address\non person.personId=address.personId\n\n```
['MS SQL Server']