Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (31.8k points)
What distinguishes an inner join from an outer join?

1 Answer

0 votes
by (32.5k points)

Inner join and outer join are two types of joins used in SQL to combine data from two or more tables. The main difference between an inner join and an outer join is in how they handle data that does not have a matching record in the other table.

An inner join only returns the records where there is a match in both tables. An outer join, on the other hand, returns all the records from one table and the matching records from the other table. If there is no matching record in the other table, the result will contain NULL values for the columns from the missing table. 

Take your database skills to the next level by mastering SQL joins with this video tutorial -

Related questions

+1 vote
1 answer
0 votes
1 answer
0 votes
1 answer
asked May 4, 2023 in SQL by neelimakv (32.1k points)
0 votes
1 answer
asked May 4, 2023 in SQL by Nandini V (32.5k points)
0 votes
1 answer
asked May 4, 2023 in SQL by vyeshma (31.9k points)

Browse Categories

...