组合两个表

数据库多表查询

outer join

SELECT
  p.FirstName,
  p.LastName,
  a.City,
  a.State
FROM Person p
LEFT JOIN Address a
  ON p.PersonId = a.PersonId