How many types of Joins in SQL Server 2005?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how we use window authentication connection with sql server.?

605


What is the main purpose of having conversation group?

474


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1446


What are the system database in sql server 2008?

552


What is indexed view? How to create it?

570






What is the difference between composite index and covering index?

488


whats new about truncate in sql server 2008?

2000


How to create a view on an existing table in ms sql server?

556


What is identity?

525


What is the name of reporting services config file and what’s it’s used for?

103


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

557


Can we delete data from a view?

517


Write SQL queries on Self Join and Inner Join.

585


When to use Inner join & when to use subquery?

560


What are different types of views?

528