Answer Posted / 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 |
Post New Answer View All Answers
iwant know IEEE formate ,how it is used and exactly where it is used? i have details it follows test plan, testcases...etc. i want real time explanation. pls any one give?
what r the measure bugs found in your project??? Give some example abt this.
How do you get programmers to build testability support into their code?
Inwhat basis the time is allocated for testing the application?
What is Pre UAT and UAT is there any difference ?
Can you explain the workbench concept?
Relative to other technical groups in the company? Relative to your staff?
Which are the different tests for apparel testing?
Why it is recommended to add verification checks to your all your scenarios?
what is the difference between PEGA based web application testing versus web application testing?
what are all the possible Test Cases for VoIP based applications
How will u decide test data to see that evey feature is thoroughly tested
Hi,all i have a desktop App. which have a feature, It's a demo version if u want full version then u have to perches it. Pls give me some idea ASAP how can i break the App.
What is deferred status in defect life cycle?
What is the difference between manual testing and automation testing?
