What are the different types of join in SQL

Question

Can you please explain what are the different joins in sql?

Answer 1

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,