what are the different types of joins?

Question Posted / swapna

4 Answers
9125 Views
Choice Solutions, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are the different types of joins?..

Answer / a.jyothsna

1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join

Is This Answer Correct ?

14 Yes

0 No

what are the different types of joins?..

Answer / desiraju venkata subramanya ka

types of joins
• outer join
• left join
• right join
• equi-join
• non-equi-join
• selfJoin

Is This Answer Correct ?

7 Yes

2 No

what are the different types of joins?..

Answer / prakash

Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join

Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins

Is This Answer Correct ?

0 Yes

1 No

what are the different types of joins?..

Answer / 123

cross join

Is This Answer Correct ?

2 Yes

5 No

Post New Answer