1. Inner Join 2. Outer Join - Left Outer Join

How many types of Joins in SQL Server 2005?

Question Posted / vishal

Answer Posted / vishal

1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is scalar user-defined function?

1035

What is a DBMS, query, SQL?

1015

How to populate a table in sql server?

917

How many types of attribute relationships are there? : sql server analysis services, ssas

1027

What is a transaction and why is it important?

1034

How many levels of sp nesting is possible?

1014

How to test subquery results with the exists operator?

1056

How to fine-tune reports?

255

What is a periodical index?

883

Can a synonym name of a table be used instead of a table name in a select statement?

988

What is role playing dimension with two examples? : sql server analysis services, ssas

970

What is indexing explain it with an example?

959

Do you know what are acid properties?

1034

Explain the phases a transaction has to undergo?

1009

What are indexes in sql?

1211