Types of Joins

Overview

Osmos Supports four primary join types

1. A left join helps you merge two sets of data while making sure you don't lose any information from the first set, even if there's no matching data in the second set. It's like adding extra details to a list without losing any names from the original list.

2. A right join is similar to a left join, but it focuses on keeping all the information from the second set of data (the right one) and adding matching information from the first set (the left one). Again, It's like merging two sets of data while ensuring you don't miss any details from the second set, regardless of whether there's a match in the first set or not.

3. An inner join is a way to combine two sets of data and only include the information that has a match in both sets. It's like creating a new list where you only keep the items that appear in both of your original lists and anything that doesn't have a match is left out.

4. A full join, also known as a full outer join, is like merging two sets of data in a way that you keep all the information from both sets. In other words, it combines the data from both sets and includes everything, whether there's a match or not.