What are the different types of joins

Answer Posted / rajesh v.g.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also

1585


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

4417


sanity testing is done during regression testing.is it true.if it is true plz explain?

1464


How to find bug in photos and videos ??

1745


in transfer funds module, how you come to know that amount has been transferred successfully or not....explain in detail

1150






How do you go about testing a project?

1533


Hi could some one please send me the testplan testcases(for 2Modules) and testscripts for mercry fliht aplication or gmail. please write those on templates and send me.In testplan plase write Testobjective, test scope, est approach, exlusions assumptios.

1564


What were the major challenges u faced while testing

2057


What is srs and brs document?

699


Can you explian $ pillar of Agile

827


Test approach to windows update?

1737


hi friends .......... from srs to signoff what r the tests the testing team will conduct either sequentially or parallel pls advice thanks in advance

1456


Hi Friends, Just One Month Back I was Join in Small Company as a Testing Eng.I have Six Month Exp. In this Company all my team memb.r fresher & PM give responsibility on us to prepare all require QC doc. for our new project.So I need ur help in this matter .How Can I start my work and Which Doc.I start to collect & From Where I get Detail Information all abt these thing. Thanks to all friends who give reply to this. Suyog

1429


You must test a trouble report where the problem cannot be reproduced. You tried using various test data files and mutations from the data files the customer sent along with the trouble report. The software does not fail the way it did at the customer's site.

2096


1.What is configuration Management? 2. Explain Impact Analysis 3. Explain Peer Review 4. what i kickoff phase of Formal Review. 5. Whatv are the phases of fundamental test process. 6. what is state transition testing. 7. what is LCSAJ 8. Test conditions are derived from where?

1524