2
Reply

What is the difference between inner and outer join? Explain with example.

Vishal Prajapati

Vishal Prajapati

May 03, 2016
697
0

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

    Ashish Srivastava
    December 21, 2017
    0

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

    Vishal Prajapati
    May 03, 2016
    0