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 is inline table-value user-defined function?

1012

How to count rows with the count(*) function in ms sql server?

951

What is the bookmark lookup and rid lookup?

943

How to stop a loop early with break statements in ms sql server?

976

What is acid properties?

1023

on line cluster can we make if yes tell me the procedure

1979

What is Sqlpaging in SqlServer 2005 ?

1016

What is triggers and its types?

955

What is SQL Azure Firewall?

134

What is an expensive query?

881

How would you choose between a clustered and a non-clustered index?

919

What is not null constraint?

1055

What is normalization according to you and explain its different levels?

899

Delete duplicate rows without using rowid.

1492

Explain indexed views and partitioned view with their syntax.

1079