Inner Join and Outer Join in SQL

Inner Join

Inner Join in Sql will returns common elements in both tables as output.If A and B are Two table it will returns values that are present in both A and B tables.

Outer Join

Outer join is of three types:

• Left Outer Join
• Right Outer Join
• Full Outer Join

Left outer join will return all values that are present in Table A and the values respective to row that are present in both tables. If table A row values are not present in table b then it returns null value for that.

Right outer join will returns all values that are present in table B but also common values that are present in both Table A and B .Values of table B tha are not present in table A returns null values for that as output.

Full outer Join will return the all the values of table A & B.