What Are Various Joins Used While Writing Subqueries?

1.	What Are Various Joins Used While Writing Subqueries?
Answer» Self JOIN-Its a join foreign key of a table references the same table. Outer Join--Its a join condition USED where One can query all the rows of one of the tables in the join condition even though they don't SATISFY the join condition. Equi-join-Its a join condition that retrieves rows from one or more tables in which one or more COLUMNS in one table are EQUAL to one or more columns in the second table.

Answer»

Self JOIN-Its a join foreign key of a table references the same table.
Outer Join--Its a join condition USED where One can query all the rows of one of the tables in the join condition even though they don't SATISFY the join condition.
Equi-join-Its a join condition that retrieves rows from one or more tables in which one or more COLUMNS in one table are EQUAL to one or more columns in the second table.

Discussion