| A: |
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. . Outer Join is used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition. |
