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

How do u prepare test environment for ur application?

2127


When to stop testing? (Or) how do you decide when you have tested enough?

1113


1) Test summary contains ? 2) Requirement Tracebility means ? 3) Test Effort contains ? 4) Test Planning Productivity ? 5) Metrics should be caluclated ? 6) Interest rate Rsik is a type ? 7) Test analysis and Design process task? 8) secured loan is a part of Liability (or) assest in a balance sheet? 9) Money Market means? 10) a ------ specifies all of the terms of a loan and the obligations borrower ? 11) what is a primary market is ? 12) Quality of Testing measure with ? 13) Company has a share with facevalue 10 rs/- and NAV of 37 after comapny has given Dividend of 35 % then How much NAV become ? ( I don't know what is NAV means, question overall Idea I am giving not 100% perfect ) the potions for these are 1) 33 2) 33.50 3) 37 4) 42 14) one compay has taken 10 million loan from a bank for a Interest rate is 10 % and base amount is 0.4% so how much they had paid monthly Emi ? they provideansews like 1) 100000 2) 114000 3) 140000 4) 104000 Remaing questions I not remember.

2699


what is entry and exit criteria and explain it?

1450


do we need to write test cases for workflow of the product for instance: there is 2 module "TRAINING ASSIGN MODULE" and "EMPLOYEE" in TRAINING assign MODULE iam assigning training to employee setp is 1.selct traning "oracle" 2.select employee u want assign "peter" 3.apply. now to check whether training assign or not GOTO EMPLOYEE module 1.click on "peter" 2.click on 'view assign to employee'link.now this is a flow do i need to write test cases for this fllow.plz help me guy mail me nirmal_rawatt@rediff.com

2025


. Is any graph is used for code coverage analysis?

2579


How to find that tools work well with your existing system?

2045


Does an increase in testing always improve the project?

1788


Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain

2098


what are the different methods to test a product in 'Japanese' language? NOTE:User is unable to perform basic functionalities while using the app..(copy, paste, text selection etc.)

1983


Can anybody give whole test cases for banking module.it should include from start to end .that will help me more.to do study.it should contain account,deposite,withdraw,fd,atm modules.?please try to give me??

2276


from where do u collect test data if u miss some data what will happen

2631


What is decision table testing?

1076


What is the procedure of manual testing?

1103


after completeing testing ,what would u deliver to the client?

2081