yokostan / Leetcode-Solutions

Doing exercise on Leetcode. Carry on!
0 stars 3 forks source link

Leetcode #175. Combine Two Tables #207

Open yokostan opened 5 years ago

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