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

How do I view a stored procedure in sql server?

969

How to get the query of a table in sql server?

877

explain how to create a new schema in a database? : Sql server database administration

1092

How to use values from other tables in update statements in ms sql server?

1092

What's the information that can be stored inside a bit column?

977

How to write an inner join with the where clause in ms sql server?

1072

Difference between Sql server reporting services and Crystal reports?

168

What are the different types of collation sensitivity?

1094

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

915

What is molap and its advantage? : sql server analysis services, ssas

965

Is port 1433 secure?

975

what are the different stages of Report Processing?

135

What are the differences between web role and worker role?

122

What is table join?

1096

What is bcnf normalization form?

1095