Combine Two Tables

按照id合并两个表Combine Two Tables
数据库左连接操作

select FirstName, LastName, City, State from 
person  left join address on person.PersonId=address.PersonId