Can you please explain the difference between inner join and outer join in database

0 votes
I don't have clear understanding between inner join and outer join . Can please explain the concept then that will be very helpful for me.
May 28, 2019 in Database by Suraj
1,106 views

1 answer to this question.

0 votes

Hi Suraj,

You have a doubt regarding inner join and outer join right?

So first to do this operation you need to have two or more tables available in your database,

Suppose here I took table1 and table2,

Inner join:  INNER JOIN selects records that have matching values in both tables.

so in this join all the matching rows( means those rows which are already available on both the tables like table1 and table2) will be fetched.

 Outer join: OUTER JOIN returns all the records from both the table(table1 and table2).

I hope this answer will able to clear your doubts.

Thank you,

answered May 28, 2019 by sampriti
• 1,120 points

Related Questions In Database

0 votes
1 answer

What is the difference between HAVING and WHERE in SQL?

HAVING: It is used to check after the aggregation ...READ MORE

answered Feb 17, 2022 in Database by Vaani
• 7,070 points
732 views
0 votes
0 answers

What's the difference between a temp table and table variable in SQL Server?

We can build temp tables in SQL ...READ MORE

Feb 25, 2022 in Database by Vaani
• 7,070 points
598 views
0 votes
0 answers

What is the difference between drop table and delete table in SQL Server?

What is the distinction between the following ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
• 38,020 points
748 views
0 votes
0 answers

What's the difference between TRUNCATE and DELETE in SQL

What distinguishes SQL's TRUNCATE and DELETE operations? Please ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
• 38,020 points
476 views
0 votes
1 answer

Difference between Inner Join & Outer Join

The difference is as follows: INNER JOIN: Returns all those ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,250 points
1,563 views
0 votes
1 answer

Performing LEFT OUTER minus INNER JOIN in Tableau

Hi Sindhu, To get the list of orders ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
3,275 views
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

You can simply write a few measures ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,890 points
1,590 views
0 votes
0 answers

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
• 38,020 points
467 views
0 votes
1 answer

Can you explain what is the difference between UNION and Join?

Hi Sahana,  I got your doubt, Checkout these ...READ MORE

answered May 30, 2019 in Database by sampriti
• 1,120 points
1,307 views
0 votes
1 answer

What are the different types of join in SQL?

Hi Suraj, You have a doubt regarding inner join ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,120 points
1,254 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP