0 votes
1 view
in SQL by (20.3k points)

Difference between inner and outer join. i am using two table and want to fetch data from both table so which type join we should use owning of that we can solve our problem.

1 Answer

0 votes
by (40.3k points)

Following is the comparison between the Inner Join and Outer Join Based on some parameters:

Comparison

Inner Join

Outer Join

DB(Database)

The size of the database returned by Inner Join is smaller than the Outer Join

This returns a comparatively larger database.

Types

No Type

Left Outer Join, Right Outer Join and Full Outer Join

Fundamental

Inner Join returns only the matching rows from both the table.

This returns all the rows from both the tables.

 For detailed information, you can refer to this: Inner Join vs Outer Join

Related questions

+1 vote
1 answer
+2 votes
1 answer
0 votes
1 answer
+3 votes
1 answer
asked Jul 3, 2019 in SQL by Tech4ever (20.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...