There are 5 types of join in sql server 2005 inner join outer join cr

How many types of Joins in SQL Server 2005?

Question Posted / mpg

Answer Posted / mpg

There are 5 types of join in sql server 2005

inner join
outer join
cross join
equi join
self join

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to create new tables with "select ... Into" statements in ms sql server?

973

What is the sql case statement used for?

1076

Why use triggers?

996

What is the server name for sql management studio?

995

How do I edit a stored procedure in sql server?

903

How many types of objects are there?

983

How many levels of sp nesting are possible?

991

What is advantage data architect?

902

What are the properties of the relational tables?

866

Define primary key?

1112

Explain what are sparse columns?

969

What are the steps to insert a table?

920

What happens if strings are casted into wrong code pages in ms sql server?

1098

what's sql server? : Sql server database administration

973

Who is the owner of a schema in ms sql server?

1058