[leetcode]Combine Two Tables

时间：2015-01-11 20:19:59 收藏：0 阅读：273

leetcode竟然有sql的题了。。两道简单的应该会做

这个题主要就是一个left join...

# Write your MySQL query statement below
SELECT Person.FirstName, Person.LastName, Address.City, Address.State
FROM Person LEFT JOIN Address 
ON Person.PersonId = Address.PersonId;

原文：http://www.cnblogs.com/x1957/p/4216993.html