With inner join, the join will only occur if the ID exists in both tables. Since no ID overlap in example, the result will be null.
Result of inner join:
ID, Name, Address
With left join, the information from first table (ie Person table in this problem) is always in the result. If the second table has matching IDs, then the info from the second table will be added after the information from the first table. If the second table does not have an ID that matches the ID from the first table, then null will be printed for where information from the second table was supposed to be added.
@jeffrey.zhang.7921 FULL JOIN / FULL OUTER JOIN / OUTER JOIN : returns rows when there is a match in one of the tables. ... Note that the OUTER keyword is optional for LEFT/RIGHT JOIN. LEFT and RIGHT joins are both outer joins. I believe there are some flavors of SQL that may require the OUTER keyword, but MySQL does not