there are five types: inner join outer join: left outer join,right outer

How many types of Joins in SQL Server 2005?

Question Posted / rupinder kaur

Answer Posted / rupinder kaur

there are five types:
inner join
outer join: left outer join,right outer join, full outer
join
equi join
cross join self join

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What were the latest updates to SQL Azure service?

113

Detail about query optimizer?

1156

How can I tell if sql server is 32 or 64 bit?

1010

What do you mean by data integrity?

1125

How can I know what locks are running on which resource?

992

Are connections to sql server encrypted?

1053

How many servers can we create in a single subscription?

162

Explain go command in sql server?

1090

What is enhanced database mirroring in sql server 2008?

1033

How to find related tables in sql server?

1001

What is ssrs?

135

Do you know what guidelines should be followed to help minimize deadlocks?

1014

Difference between LEN() and DATALENGTH() in sql server ?

1170

How can you insert null values in a column while inserting the data?

1340

How much memory that we are using in Logshipping Concept?

1842