Expain variations of JOIN?

1.	Expain variations of JOIN?
Answer» 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.

Answer»

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.

Discussion