What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....

Answer Posted / prangya mishra

joins are used for retreiving the information from multiple
tables at a time & presenting it.
we have 5 different types of joins
1.Equi join
2.Non-Equi join
3.Self join
4.Cartesian join
5.outer join

Is This Answer Correct ?    5 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between “where” and “having” clause in sql server?

558


What happens if null values are involved in comparison operations?

518


What is difference between rownum and rowid?

484


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

523


What is a field in a table?

551






What is logshipping and its purpose?

531


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

511


Is null vs coalesce?

475


How to enable/disable indexes?

561


What is the security principal at the server level that represents your session?

536


What is difference between inner join and join?

516


Define model database?

551


What are the diifferences between the ms sql server vs mysql?

628


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

463


What is data set in report?

95