Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the different types of joins

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can test condition,testcase and testscript help u in performing the static testing

2070


hi what are the test cases for web application..i need these example..please..mail me at mina_ims@yahoo.com

2014


1.For a single module how many builds are possible 2.what will be the max or min time to finish up an single module

2057


Is anybody have the telecom systems test cases from start to end?

2083


How do you perform configuration management with typical revision control systems?

2183


Can you explain equivalence partitioning?

1028


How can we test for drastic (severe) memory leakages?

1072


Hi Could someone please provide Siebel Testing Interview questions for 5 years exp.

4923


i want to for technical interview question paper along with in tesrviwe Phases i need

1959


What is severity and priority of bug? Give some example.

1179


Can you explain usability testing?

1154


If project wants to release in 3months what type of risk analysis you do in test plan?

1203


What is the difference between three tier and two tier application?

1136


Build with fixes has been deployed on QA environment if asked by your manager to reproduce how can you reproduce the issues? (by using the previous build) Can you access the previous build? If so ,what are the tools or how can you access?

2095


write the test senario on opening door in the flow diagram format

1430