LeetCode Combine Two Tablesを解いた

問題

https://leetcode.com/problems/combine-two-tables/

解いた

SELECT
    Person.firstName,
    Person.lastName,
    Address.city,
    Address.state
FROM
    Person
    LEFT OUTER JOIN
        Address
    ON  Person.personId = Address.personId

結果

LEFT OUTER JOIN すれば良いですね。あれ日本語でなんて言うんだっけ？