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.


Discussion

No Comment Found

Related InterviewSolutions