shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

 

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.

rajakumar_na

 Profile Answers by rajakumar_na 

• Nov 16th, 2007

 

Hi shravanam,
Wht is this u r wrong?
Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....)