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 completely remove sql server instance?

1102

Why SQL Agent is used?

1150

What is a partition key?

954

Can we call stored procedure in view in sql server?

898

What is resource db in sql server?

1024

What do you mean by authentication modes in sql server?

1083

What are different types of statements that are supported by sql?

1047

How many levels of sp nesting are possible?

1026

What are the character string functions supported by sql server 2005?

1013

What is the main difference between ‘between’ and ‘in’ condition operators?

1191

What is the current pricing model of SQL Azure?

104

What is the difference between count () and rowcount ()?

1027

What is the Control Flow in SSIS

1094

What are partitioned views and distributed partitioned views?

1022

Explain what are the restrictions while creating batches in sql server?

1068