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

Question

I don't have clear understanding between inner join and outer join . Can please explain the concept then that will be very helpful for me.

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,