Vishal Prajapati
What is the difference between inner and outer join? Explain with example.
By Vishal Prajapati in Databases & DBA on May 03 2016
  • Ashish Srivastava
    Dec, 2017 21

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

    • 0
  • Vishal Prajapati
    May, 2016 3

    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).

    • 0