A naukri.com initiative
Dev
2M
390
Image Credit: Dev
What is the difference between "INNER JOIN" and "OUTER JOIN"?
- An inner join of A and B gives the result of A intersect B.
- An outer join of A and B gives the results of A union B.
- An inner join gives the intersection of the two tables, i.e. the common rows.
- An outer join gives all rows from one table plus the common rows from the other table.
Read Full Article
23 Likes
For uninterrupted reading, download the app