inner join outer join cross join equi join self join

How many types of Joins in SQL Server 2005?

Question Posted / kittu

Answer Posted / kittu

inner join
outer join
cross join
equi join
self join

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to create new tables with "select ... Into" statements in ms sql server?

927

Does the unique constraint create an index?

985

What is replace and stuff function in sql server?

996

What is #table in sql server?

994

What is report subscription?

117

What are the differences between char and nchar in ms sql server?

1005

What is sql injection and why is it a problem? : sql server security

1066

How to name query output columns in ms sql server?

915

What are the 3 types of schema?

1041

How do you clear a log file?

979

What is the partitioning method?

972

What is Dependency Injection and provide example?

1039

What are the properties of primary key?

911

What is the difference between a fill factor of 100 and 0?

920

What is report snapshot?

142