LeetCode SQL: Combine Two Tables 

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

居然出SQL的题目了，左连接就行

posted @ 2015-01-23 00:09  卖程序的小歪  阅读(188)  评论(0)  编辑  收藏  举报