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 do I create a stored procedure in sql server?

1022

Explain left outer join and right outer join?

1025

Do you know the policy based administration feature of sql server 2008?

947

Do you know clustered and non-clustered index?

972

What is the sql case statement used for?

1087

What is the difference between getdate and sysdatetime?

994

What is mscorsvw.exe - process - microsoft .net framework ngen?

943

What are the types of database schema? : sql server analysis services, ssas

1123

What is cached report?

143

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

951

how we use window authentication connection with sql server.?

1142

What is SQL Azure Firewall?

136

How to trouble shoot if unable to connect SQL Server

1984

Can group by and orderby be used together?

1005

How you trouble shoot when any job fails

1929