组合两个表 === 考察内容:JOIN  因为用户不一定有地址所以采用外连接 ``` SELECT p.FirstName,p.LastName,a.AddressId,a.Cstate FROM Person as p LEFT JOIN Address as a ON p.PersonId = a.PersonId ```