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

What is the significance of master, tempdb and model databases?

708

Do you know how to store and query spatial data?

780

What are partitioned views?

743

How to count groups returned with the group by clause in ms sql server?

739

what's the maximum size of a row? : Sql server database administration

737

How to create a large table with random data for index testing in ms sql server?

738

Explain SSRS Architecture?

163

What is the server name for sql management studio?

655

What are some examples of schemas?

705

What is a collation?

808

What is the difference between the 2 operating modes of database mirroring?

808

Where in ms sql server is ’100’ equal to ‘0’?

798

When would you use it?

759

What are the differences between ms sql server & oracle?

742

Explain about extended stored procedure?

677