Types of joins ?

Question Posted / mathur

3 Answers
10646 Views
Digital GlobalSoft, HeadStrong, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Types of joins ?..

Answer / ramesh yadav

IN ORACLE 9i.

Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join

Non - Equi Join

Outer Join
Left outer join
Right outer joi
Full outer join

Self join
Cartesian Product

Is This Answer Correct ?

9 Yes

0 No

Types of joins ?..

Answer / bipin

sql-server

inner join
outer join
left outer join
right outer join
full outer join
cross join

oracle sql

inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join

Is This Answer Correct ?

8 Yes

2 No

Types of joins ?..

Answer / vinodkumar.r

2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer

Is This Answer Correct ?

7 Yes

2 No

Post New Answer