Types of Joins 1.Inner Join 2.Outer Join -- Left Outer Join -- Ri

How many types of Joins in SQL Server 2005?

Question Posted / abi

9 Answers
11646 Views
CarrizalSoft Technologies, HCL, I also Faced
E-Mail Answers

Answer Posted / abi

Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know hot add cpu in sql server 2008?

895

What is filter index?

904

What are the types of lock supported by ?

995

What method is used by the Command classes to execute SQL statements that return single values?

1003

What is importing utility?

928

What are four major operators that can be used to combine conditions on a where clause?

983

Do you know how to implement service broker?

885

Can two different columns be merged into single column? Show practically?

1012

Which rendering formats are affected by the pagesize properties?

134

How to enable/disable indexes?

1011

How do I find the size of a sql server database?

870

How to create percentile function?

139

Which are ddl commands?

969

What is @@rowcount in sql?

947

What stored by the master? : sql server database administration

1026