fullouter join
Learn how to use the fullouter join flavor to merge the rows of two tables.
join flavors
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.
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.