Inner Join Outer Join Crros Join

How many types of Joins in SQL Server 2005?

Question Posted / g.ramesh

Answer Posted / g.ramesh

Inner Join
Outer Join
Crros Join

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How you trouble shoot when any job fails

1932

What are the steps you will take to improve the performance of a poor performing query?

970

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1071

How to create function without parameter in sql server?

1049

Is sql server implemented as a service or an application? : Sql server database administration

959

How to select some specific rows from a table in ms sql server?

1001

Can you move the resources after pausing the node? : sql server database administration

1093

What will be query used to get the list of triggers in a database?

998

What does executeupdate return?

969

Write a query to find 5th highest amount paid from the customer table.

928

What is measure group, measure? : sql server analysis services, ssas

1001

Difference between primary key and clustered index?

998

Explain the benefits of user-defined functions?

1052

What are indexes in sql?

1271

What are types of subqueries?

1060