As we know, JOIN retrieves data from the various table.

There are three forms of JOIN-

1) INNER JOIN : is the most common method of JOIN in which user get row from multiple tables when join condition is satisfied.

2) LEFT OUTER JOIN : This method returns all row from the left-hand table when ON condition is satisfied.

3) RIGHT OUTER JOIN : This method returns all row from the left-hand table when ON condition is satisfied.

BY Best Interview Question ON 13 Jan 2019