Combine Two Tables.md

MySQL Solution

SELECT FirstName, LastName, City, State FROM Person
LEFT JOIN Address USING(PersonId)

Notes

We could also replace

USING(PersonId)

with

ON Person.PersonId = Address.PersonId

The ON clause is used to join tables where the column names don’t match in both tables.

Links

• github.com/RodneyShag