There are 5 types of join in sql server 2005 inner join outer join cr

How many types of Joins in SQL Server 2005?

Question Posted / mpg

Answer Posted / mpg

There are 5 types of join in sql server 2005

inner join
outer join
cross join
equi join
self join

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How does Report Builder support Analysis Services cubes?

158

What is snapshot parameter in ssrs?

155

When to use Inner join & when to use subquery?

1231

What is store procedure?

1109

What is ms sql server index?

1146

Explain the microsoft sql server delete command? : SQL Server Architecture

1140

Find nth lowest salary or get nth lowest salary?

1079

How can sql server instances be hidden? : sql server security

1209

How to create a view on an existing table in ms sql server?

1182

What is sub-query in sql server? Explain its properties.

1128

What are triggers? How do you invoke a trigger on demand?

1362

What is the query and subquery?

1119

Explain about Normalization?

1117

How to attach adventureworkslt physical files to the server?

1160

What number aggregate functions are accessible there in sql?

1126