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,680 points
36 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,100 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,680 points
28 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,680 points
729 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,680 points
43 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,140 points
40 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
• 12,780 points
8 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,520 points
30 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,590 points
87 views
0 votes
1 answer
0 votes
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,100 points
787 views
0 votes
1 answer

Difference between SQL and PL/SQL

SQL is a query language that allows ...READ MORE

answered Oct 15, 2018 in Database by DataKing99
• 8,100 points
98 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.