http://en.wikipedia.org/wiki/Join

What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....

Question Posted / wiki man

Answer Posted / wiki man

http://en.wikipedia.org/wiki/Join_(SQL)

Is This Answer Correct ?

17 Yes

17 No

Please Help Members By Posting Answers For Below Questions

How to enable tcp/ip protocol on a sql server?

1212

How to create a view with data from multiple tables?

1063

Does group by or order by come first?

996

what is create database syntax? : Sql server database administration

1162

What is normalization of database?

1177

How to list all login names on the ms sql server?

1184

What is clustered vs nonclustered index?

1001

Explain about remote stored procedure?

1060

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2008

What is a collation in ms sql server?

1133

What are page splits? : SQL Server Architecture

1037

How do I create a partition table in sql server?

1182

How to perform key word search in tables?

1002

Write an SQL query to obtain the 2nd highest salary.

1125

Why use “pivot” in sql server?

1176