https://www.essentialsql.com/what-is-the-difference-between-an-inner-and-outer-join/

nner JoinInner join is the most common type of Join which is used to combine the rows from two tables and create a result set containing only such records that are present in both the tables based on the joining condition (predicate).where asOuter JoinOuter Join, on the other hand, will return matching rows from both tables as well as any unmatched rows from one or both the tables (based on whether it is single outer or full outer join respectively).