rajarajana

 Profile Answers by rajarajana 

• Feb 3rd, 2006

 

hai guys, different type of joins are 1) self join 2) equijoin 3) non equijoin 4) cross join 5) natural join 6) full outer join 7) outer join 8) left outer join 9) right outer join

hruday ranjan mohanty

• Feb 9th, 2006

 

types of join:1.Self Join-when u need to join a table to itself2.Equi Join:-The relation between the employee table and dept table is an equi join that both tables must be equal3.Non equi Join:-The relationship is obtained using operator other than = operator.4.Outer Join:-The missing rows can be obtained is outer join operation is used.It returns rows from one table that have no direct match in other table.5.Cross Join:-produces cross product of two tables.6.Natural Join;-It is based on all columns in two tables that have same name or same column.7.Inner Join-To find out only matched columns.8.Full outer join:-inner join+left outer join+right outer join.

sreyas

• Mar 17th, 2006

 

Hi,

1,Inner join

2,Self join

3,Left outer join

4,Right outer join

sreyaskvmce&it

 Profile Answers by sreyaskvmce&it 

• Mar 17th, 2006

 

The different type of joins are:

Self join

Inner join

Cross join

Left outer join

Right outer join

sujaykumar shome

• Mar 23rd, 2006

 

Inner Join, Cross Join, Outer Join, Left Outer Join, RightOuterjoin.

ashok

• Apr 28th, 2006

 

please send me definitions of right join,left join,inner join, outer joins.

venkat

• May 9th, 2006

 

self join,inner join,left outer join,left outer join,

pankaj pandey

• Jul 19th, 2007

 

self join
inner join
left outer join
left outer join
cross join
hash join
merge join

SUSHIL K

• Aug 1st, 2007

 

Mainly 4 types of joins

equi join (also termed as simple join & inner join)
non-equi join
self join
outer join

other joins are : cross join, natural join.

srinu.tenali

 Profile Answers by srinu.tenali 

• Dec 24th, 2007

 

hi,joins are 4 types:1)INNER JOIN 2)OUTER JOIN 3)SELF JOIN 4)CROSS JOIN1)INNER JOIN:it has 2 typesa)equi joinb)noneqwui join2)outer join:it has 3 typesa)left outer joinb)right outer joinc)full outer join

khjbasha

 Profile Answers by khjbasha 

• Jul 15th, 2009

 

There are 6 types of joins:

1. Inner Join: This will display the matching rows from the tables after comparing values present in a common column.
2.
Outer Join: When you want all rows from a table and matching rows from the another table then we use this join.
In outer join we have two types
       a. Left
Outer Join and
       b. Right Outer Join
3. Cross Join:
This join produces a Cartesian product, that is each row fro one table will be mapped to each row of another table.
4.
Self Join: When a row in a table has to co-relate with other rows of the same table then use self join by aliasing the same table.
5.
Equi Join: A join that uses an * sign in the select list and displays
redundant column data in the result set is termed as equi join.
6. Natural
Join: A join that restricts the redundant column data from the result set is known as natural join.

Abdisa

• Jan 8th, 2012

 

1:full join
2:Inner join
3:Rirht join
4:left join

raviraj044

 Profile Answers by raviraj044 

• Jan 24th, 2012

 

1. Join
2. Inner Join
3. Right Join
4. Left Join
5. Full Join
6. Cross Join

Pradeep

• Feb 21st, 2012

 

Join,
Inner join,
Outer join,
Left join,
Right join,
Full join

raman sharma

• Mar 2nd, 2012

 

there are two type of join

1)inner join
inner join have a three type
I)equi join
II)nonequi join
III)self join

and outer join have a two type

I)right outer join
II)left outer join

and one is a ANSI join that a advance