Difference between Inner Join Outer Join

Question

Hi!!

I am new to the database, can someone tell me the difference between  Inner Join & Outer Join?

Answer 1

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