What are the different types of joins

Answers were Sorted based on User's Feedback



What are the different types of joins..

Answer / uday kumar. a

Two types of joins
1. Inner Join
2. Outer Join
2.a Left outer join
2.b Right outer join

Is This Answer Correct ?    7 Yes 2 No

What are the different types of joins..

Answer / rajesh v.g.

In SQL Server, we have the following joins
1.Self Join
2.Inner Join
3.Cross Join
4.Outer Join
4.1 Left Outer Join
4.2 Right Outer Join
4.3 Full Outer Join

Is This Answer Correct ?    4 Yes 0 No

What are the different types of joins..

Answer / shankar

2 types:
1. Inner Join
2. Outer Join
3. Cross Join
1. Inner Join: Inner Join displays matched rows.
2. Outer Join: Outer Join displays matched rows as well as
unmatched rows. Outer Joins again classifed into 3 types.
2a. Left Outer Join: Matched rows as well as left table
unmatched rows.
2b. Right Outer Join: Matched rows as well as right table
unmatched rows.
2c. Full Outer Join: Matched rows as well as left table
unmatched rows and right table unmatched rows.
3. Cross Join: It will display the cartegion product of the
tables.

Is This Answer Correct ?    3 Yes 0 No

What are the different types of joins..

Answer / suneel reddy

Inner Join
Outer join
self join
cross join

Is This Answer Correct ?    4 Yes 2 No

What are the different types of joins..

Answer / rk_(processmap)

1)Inner join A join that displays only the rows that have
a match in both joined tables
2)Outer join A join that includes rows even if they do
not have related rows in the joined table
i) Left outer join All rows from the first-named
table
ii) Right outer join All rows in the second-named
table
iii) Full outer join All rows in all joined
tables are included
3)Cross join A join whose result set includes one row for
each possible pairing of rows from the two tables

http://msdn2.microsoft.com/en-us/library/zt8wzxy4
(VS.80).aspx

Is This Answer Correct ?    1 Yes 0 No

What are the different types of joins..

Answer / giribabu

1)Simple Join
a)Equi join
b)Non Equi-join
2)Self join

3)Outer Join

Is This Answer Correct ?    1 Yes 1 No

What are the different types of joins..

Answer / smiley

1)Inner Join
- Natural Join
- Cross Join
2)Outer Join
- LEFT Outer Join
- RIGHT Outer Join
- FULL Outer Join
3)Merge Join
4)Hash Join
5)Sort-Merger Join

Is This Answer Correct ?    0 Yes 0 No

What are the different types of joins..

Answer / hema

equi join
non equi join
left outer join
right outer join

that's it ok......

Is This Answer Correct ?    0 Yes 0 No

What are the different types of joins..

Answer / knight rider

Types of Joins are:
1.Inner/Simple joins:a)Equi join b)Non-Equi join c)Self join
2.Outer join:a)Left outer join b)Right outer join c)Full
outer join
3.cross join or cartesian product join
4.Natural join

Is This Answer Correct ?    0 Yes 0 No

What are the different types of joins..

Answer / guest

1. Cartesian Join(product join)
2. Inner Join(Equi join)
3. Outer Join
3.1 Left Outer Join
3.2 Right Outer Join
3.3. Full Join
4. Self Join

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

What is a defect age?

0 Answers  


What is localization testing?

4 Answers  


WAT IS RTVM?

2 Answers   TCS,


How to kill cookies from Web page?

4 Answers  


What are the minimum requirements to start testing?

6 Answers  






Tell the test cases to test Login Password screen?

7 Answers   CybAge,


developer says it is not defect.then as a test engineer what u will do?

8 Answers   Cognizant,


I u dont have SRS doc or dont have any info about product then how will u test it?

4 Answers  


what is integration testing technique(like topdown,bottomup and hybrid)explain me friends

2 Answers  


Book by Which author is best to use? 1)Erik Van Veenendaal 2)Rex Black 3)Grahum

1 Answers  


how to do testing estimation ? is there any genearl formula for that ?

3 Answers  


What is test management?

0 Answers  


Categories