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 perform an unattended install of sql server 2000?

1086

Explain ranking functions?

1050

What does set rowcount do?

910

What is indexing explain it with an example?

1013

What is an index in a database?

979

What is sql server 2000 work load governor?

1065

What are different types of table joins?

1011

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2484

What is the user of Primary key?

990

Explain system functions or built-in functions? What are different types of system functions?

980

What are the new data types are introduced in sql 2000?

907

State a few properties of relational databases?

1128

How to access the inserted record of an event?

1049

what is normalization? Explain different levels of normalization? : Sql server database administration

1331

What is database black box testing?

1033