What are the different types of join in SQL?

0 votes
Can you please explain what are the different joins in sql?
May 27 in Database by Puja
110 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 by sampriti
• 1,100 points

Related Questions In Database

0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by darklord
• 6,190 points
113 views
0 votes
1 answer

What are the different types of index?

There are three types of index namely: Unique ...READ MORE

answered Oct 17, 2018 in Database by darklord
• 6,190 points
299 views
0 votes
1 answer

What are the different authentication modes in SQL Server? How can it be changed?

Windows mode and Mixed Mode – SQL ...READ MORE

answered Oct 29, 2018 in Database by darklord
• 6,190 points
82 views
0 votes
1 answer

What are the ways to get the count of records in a table

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,190 points
96 views
0 votes
1 answer

Different types of SQL Joins

The 4 main kinds of Joins present ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,130 points
169 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
53 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,640 points
225 views
0 votes
1 answer
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
104 views
0 votes
1 answer

How to sort the data in sql ?

Hi Akash,  If you want to sort ...READ MORE

answered May 29 in Database by sampriti
• 1,100 points
38 views