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

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

Answers (1)

Add Answer
Umang Ramani Marked As Accepted
Staff answered 3 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