What is the difference between "INNER JOIN" and "OUTER JOIN"?

Forums SQLWhat is the difference between "INNER JOIN" and "OUTER JOIN"?
Staff asked 2 years ago

Answers (2)

Add Answer
prinkesha lathidadiya Marked As Accepted
Staff answered 2 years ago
Inner Join

It is a specific kind of SQL join procedure. When two or more tables with at least one characteristic in common are merged, the procedure known as an inner join is performed. It won’t return anything if the tables don’t share any attributes.

Outer Join 

It is a specific kind of SQL join procedure. Even if the join condition fails, an outer join operation will nevertheless return combined tuples from the given table.

In SQL, there are three different forms of outer joins:

  1. Left Outer Join
  2. Right Outer Join
  3. Full Outer Join

 

Staff answered 2 years ago

The primary distinction between an INNER JOIN and an OUTER JOIN is that the inner join retains just the information from both tables that is connected to each other (in the resulting table). An Outer Join, on the other hand, will maintain information in the resultant table that is unrelated to the original table.

Subscribe

Select Categories