What are the different types of joins
- 11 Answers
- 14303 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 |
how you setup steps to start a project
What is Hybrid testing?
1. fault based testing is reversed of which testing? option.1 conventional software testing Option 2Operations and classes that are critical or suspect Option 3 Use-case validation Option 4White-box testing of operator algorithms 2. Testing OO class operations is made more difficult by Option 1 Encapsulation Option 2 Inheritance Option 3 Polymorphism Option 4 Both Inheritance and Polymorphism 3. Which of these techniques is not useful for partition testing at the class level Option 1 attribute-based partitioning Option 2 category-based partitioning Option 3 equivalence class partitioning Option 4 state-based partitioning 4.Client/server architectures cannot be properly tested because network load is highly variable. Option 1 true Option 2 false 5. Real-time applications add a new and potentially difficult element to the testing mix Option 1 performance Option 2 reliability Option 3 security Option 4 time 6.Which one is not key term used in internal control and security Option 1 Threat Option 2 Risk Control Option 3 Vulnerability Option 4 Exposure 7.Acceptance testing occurs only at the end point of the development process; it should be an ongoing activity that test both interim and final products. Option 1 true Option 2 false 8.Static testing requires...? Option 1 Binaries Option 2 Source code Option 3 Product Option 4 Executables 9.etesting is testing the application with multiple sets of data is called retesting Option 1 true Option 2 false
In any application there are so many fields. So tester have to test each field with Special chars., Alphabetic value, Alphanumeric value, Blank Space. etc. I am testing with all these inputs but should I have to consider these into test cases. Because rather than these there many functionalities to check.Please Guide me properly
u posted a bug with screenshots and steps to reproduce but still the developer is not accepting this is a bug. in dev system it is not reporducing . how u'll convince he developer? (if the developer is in india or onsite(give the answer for both the cases)
What is the difference between manual testing and automation testing?
what is the output of this query selet * from employee where 1=2
what is the difference between client-server application and web based application?
what is ur favourite bug?
In which type of testing testing started from requirement phase?
3 Answers Cap Gemini, Persistent,
They showed me a Web page containing 3 text boxes labeled as Name, D.O.B & Blood Group.It also have 3 Buttons as OK, CANCEL,Reset. They told me that 1) when you click on OK it'll route you to the next page and save the data in the database. 2) When you click on CANCEL it'll route you to the previous page. 3) When you click on Reset it'll clears all the entries made by you. Now they asked me to write Test cases to test the functionality of that web page & asked me to write 1 critical test case after which they will give final go ahead to test the rest of the application... I wasn't able to write the critical test case. Plz answer.
What is data flow diagram?
Automation Testing 
