Deloitte Interview Question

Difference between Inner Join and Outer join.

Interview Answer

Anonymous

Jun 8, 2022

An INNER JOIN and an OUTER JOIN is that the inner join will keep only the information from both tables that's related to each other (in the resulting table). An Outer Join, on the other hand, will also keep information that is not related to the other table in the resulting table