• Full join

    Full join

    FULL JOIN 称为 FULL OUTER JOIN

    FULL JOIN 关键字会从左表和右表那里返回所有的行, 即使没有匹配