How many types of Outer Joins?What are they?

Answer Posted / g.ramesh

We have 3 Types of Outer Joins.
1.Left Outer Join
2.Right Outer Join
3.Full Outer Join

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What the class forname () does?

526


What is user defined datatypes and when you should go for them?

563


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

96


What is transaction server auto commit?

562


Explain trigger and trigger types?

542






How to test values returned by a subquery with the in operator?

652


What is SQL Azure Firewall?

116


Explain about nested stored procedure?

590


How you can move data or databases between servers and databases in sql server?

550


What is the difference between count and distinct count?

455


What is bulkcopy in sql?

548


Tell about MOM Tool(Microsoft Operator Manager)?

1401


Sql server reporting services vs. Crystal reports.

96


What is a trigger and types of a trigger?

551


What is the difference between the application object and session object?

583