inner join outer join cross join equi join self join

How many types of Joins in SQL Server 2005?

Question Posted / kittu

Answer Posted / kittu

inner join
outer join
cross join
equi join
self join

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

923

Does sql server use t sql?

994

What are the steps to insert a table?

925

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

146

What the different types of Replication and why are they used?

1045

How to create an multi-statement table-valued function?

974

Explain optimistic and pessimistic concurrency?

973

Working with TLogs

1822

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

962

How to read data in a table with "select" statements?

952

What is 4nf in normalization form?

1006

Explain about SQL server 2005?

957

What is sqlservr.exe - process - sql server (sqlex?press)?

1088

What are acid properties of transaction?

935

What is the difference between clustered and non-clustered indexes in ms sql server?

983