What is the difference between "INNER JOIN" and "OUTER JOIN"?
Answers (1)
Add AnswerThe 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.