INNERSpecifies all matching pairs of rows are returned. Discards unmatched rows from both tables. This is the default if no join type is specified.FULL [OUTER]Specifies that a row from either the left or right table that does not meet the join condition is included in the result set, and output columns that correspond to the other table are set to NULL. This is in addition to all rows usually returned by the INNER JOIN.LEFT [OUTER]Specifies that all rows from the left table not meeting the join condition are included in the result set, and output columns from the other table are set to NULL in addition to all rows returned by the inner join.RIGHT [OUTER]Specifies all rows from the right table not meeting the join condition are included in the result set, and output columns that correspond to the other table are set to NULL, in addition to all rows returned by the inner join.
当第二个（底端）输入中没有匹配行时，Left Anti Semi Join 逻辑运算符返回第一个（顶端）输入中的每一行。如果 Argument 列内不存在任何联接谓词，则每行都是一个匹配行。Left Semi Join
当第二个（底端）输入中有匹配行时，Left Semi Join 逻辑运算符返回第一个（顶端）输入中的每行。如果 Argument 列内不存在任何联接谓词，则每行都是一个匹配行。Right Anti Semi Join
当第一个（顶端）输入中没有匹配行时，Right Anti Semi Join 逻辑运算符将输出第二个（底端）输入中的每行。匹配行的定义是满足 Argument 列内的谓词的行（如果不存在谓词，则每行都是一个匹配行）。Right Semi Join
当第一个（顶端）输入中有匹配行时，Right Semi Join 逻辑运算符返回第二个（底端）输入中的每行。如果 Argument 列内不存在任何联接谓词，则每行都是一个匹配行。