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.

GOPAL

• Jul 28th, 2015

Joins are used to join the columns of different tables. Types of Joins: 1. Inner Joins, 2. Outer Joins Inner Joins are sub divided into two types 1. Self Join, 2. Equvi Join Self Join is used to joi...

sukanya

• Jun 28th, 2015

Can any one tell me what is self join? What is difference between GROUP BY and HAVING?

Answer Question  Select Best Answer