1.

What Is A Join? Explain The Different Types Of Joins?

Answer»

Join is a query, which RETRIEVES RELATED columns or rows from multiple tables.
Self Join - JOINING the table with itself.
Equi Join - Joining two tables by equating two common columns.
Non-Equi Join - Joining two tables by equating two common columns.
Outer Join - Joining two tables in such a way that query can ALSO RETRIEVE rows that do not have corresponding join value in the other table.

Join is a query, which retrieves related columns or rows from multiple tables.
Self Join - Joining the table with itself.
Equi Join - Joining two tables by equating two common columns.
Non-Equi Join - Joining two tables by equating two common columns.
Outer Join - Joining two tables in such a way that query can also retrieve rows that do not have corresponding join value in the other table.


Discussion

No Comment Found

Related InterviewSolutions