Difference between Inner Join & Outer Join

0 votes
Hi!!

I am new to the database, can someone tell me the difference between  Inner Join & Outer Join?
Sep 7, 2018 in Database by CodingByHeart77
• 3,690 points
110 views

1 answer to this question.

0 votes

The difference is as follows:

  • INNER JOIN: Returns all those records that have matching values in both tables
  • LEFT OUTER JOIN: Return all the records from the left table, and the matched records from the right table
  • RIGHT OUTER JOIN: Return all records from the right table, and the matched records from the left table
  • FULL OUTER JOIN: Return all  those records when there is a match in either the left or right table
answered Sep 7, 2018 by DataKing99
• 8,130 points

Related Questions In Database

0 votes
1 answer

Difference between STUFF & REPLACE function

STUFF Function: This function is used to ...READ MORE

answered Oct 10, 2018 in Database by CodingByHeart77
• 3,690 points
731 views
0 votes
1 answer

Difference between primary key a composite key

Primary key is that column of the table ...READ MORE

answered Sep 5, 2018 in Database by CodingByHeart77
• 3,690 points
1,726 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,690 points
93 views
0 votes
1 answer

Difference between clustered and non clustered index in SQL

The differences between the clustered and non ...READ MORE

answered Sep 28, 2018 in Database by darklord
• 6,170 points
108 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 in Tableau by Cherukuri
• 31,840 points
153 views
0 votes
1 answer

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

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

answered May 28 in Database by sampriti
• 1,100 points
95 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 in Database by sampriti
• 1,100 points
82 views
0 votes
1 answer

Is it possible to access Couchbase by terminal?

What you want to accomplish isn't possible ...READ MORE

answered Apr 29, 2018 in DevOps & Agile by DareDev
• 6,810 points
49 views
+1 vote
1 answer

Difference between cross join and natural join

The cross join produces the cross product ...READ MORE

answered Oct 12, 2018 in Database by DataKing99
• 8,130 points
2,757 views
+1 vote
2 answers

Difference between SQL and PL/SQL

In Oracle database administration, there are two ...READ MORE

answered Sep 25 in Database by gautham
201 views