Expain variations of JOIN?
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