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

What is ofx testing?

764


hello frens. Im Arun from the uk. im planning to apply for tester jobs with 3yrs experience. the problem is i dont have resumes. i have to mention atleast 3 projects (preferably financial projects) in my CV. im totally blank. can u plz send ur CV's to my email.... arunmoses1982@yahoo.com. this would be a great help from you guyz. n u need any help from me? just mail me n ill get in touch with u. Thanx.

1454


If anybody from banglore having the real time exp in manual testing with 3+ yrs exp and looking for change send your profile to vinodhanandhan@gmail.com

1498


What type of testing you perform in organization while you do system testing, give clearly?

695


Hi , Please send me the interview questions which were asked in manual testing mainly the test cases asked to write in interview.

1492






What are the disadvantages of manual testing?

647


what is dib format?

1468


How the application is launched to the production environment?

1189


Explain briefly your project.

1697


could anyone explain application testing in sequence order i don't have any experience in that

1496


how deployment phase of SDLC differs in product based and in service based company ?

2534


Can any one say me how to do Performance testing step by step plz for a desktop application(offline application).all the data is stored in internal server itself can any plz help me. ts quite urgent friends.

1488


How do u determine,what to be tested?

1612


When should you opt for manual testing over automation testing?

776


Test cases on send/ receive button of Microsoft outlook.

4094