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

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.

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