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

Can group by be used without aggregate functions?

923

How can I check that whether automatic statistic update is enabled or not?

1042

How to set a database state to offline in ms sql server?

1046

Can group functions be mixed with non-group selection fields in ms sql server?

943

What encryption security is available in sql azure?

101

How can we rewrite sub-queries into simple select statements or with joins?

981

How to compare the top two records using sql?

1342

What is attribute hierarchy? : sql server analysis services, ssas

1020

What is the difference between varchar and nvarchar?

941

How to add a new dsn with the odbc driver for sql server?

1060

What is normalization of database?

1105

Can We Use Data-grids For Our Report In Ssrs?

184

what is the difference between delete table and truncate table commands? : Sql server database administration

1034

Where sql server usernames and passwords are stored in a sql server?

989

Indexes are updated automatically is the full-text index also updated automatically?

1029