What are the different types of joins
- 11 Answers
- 14994 Views
- SumTotal, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / suneel reddy
Inner Join
Outer join
self join
cross join
| Is This Answer Correct ? | 4 Yes | 2 No |
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 |
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 |
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 |
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 |
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 |
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 |
is there any checklist to check SRS document
what we get from srs doc ?
What is open issue?please explain in detail?
What is AGP?what is setup.inf?What are the ways to install driver?
How much time it will take for regression testing
Where will you give the Reproduce option in Bug report?
What is Mixed Testing
Hi, what is tier1.tier2.tier3 company.
what are the different things we test other than field level and form level validatons in functional testing
Hi Friends, Plz answer my these questions on sqt.qae@gmail.com Why you want to be software tester? As new to testing what kind of work is to be there in testing in detail...in testing What to study in manual testing or automation testing from interview point of time? Is there we have choice to choose domain while interview time..? Reply ...on my email
EXPLAIN A SCENARIO AND FEW TEST CASES FOR COMPATABILITY TESTING?
can any one send me the ans for this,what are different types of test scenarios?
Automation Testing 
