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
69 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,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
45 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
1,317 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
67 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
69 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
• 21,390 points
56 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
50 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
51 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
40 views
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
1,349 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
143 views