join flavors


fullouter join

Learn how to use the fullouter join flavor to merge the rows of two tables.

inner join

Learn how to use the inner join flavor to merge the rows of two tables.

innerunique join

Learn how to use the innerunique join flavor to merge the rows of two tables.

leftanti join

Learn how to use the leftanti join flavor to merge the rows of two tables.

leftouter join

Learn how to use the leftouter join flavor to merge the rows of two tables.

leftsemi join

Learn how to use the leftsemi join flavor to merge the rows of two tables.

rightanti join

Learn how to use the rightanti join flavor to merge the rows of two tables.

rightouter join

Learn how to use the rightouter join flavor to merge the rows of two tables.

rightsemi join

Learn how to use the rightsemi join flavor to merge the rows of two tables.