MySQL/175. Combine Two Tables 组合两个表

题目

MySQL/175. Combine Two Tables 组合两个表


MySQL/175. Combine Two Tables 组合两个表

 

 

 

代码部分一(260ms 89.84%)

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