What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
- 9 Answers
- 60726 Views
- DELL, i Tech, Infosys, Siemens, TCS, I also Faced
- E-Mail Answers
Answer Posted / raji
Different Types Of JOINS:
Most of the joins you will come across are based on
equality, with the equijoin being the most dominant.
In this chapter you learned about equijoins; there are
other types of joins you must become familiar with, most
notably the self-join, the nonequijoin, and the outer join.
Equijoin or Inner Join (Equality) : Traditional comma-
separated join or ANSI JOIN syntax (including optional
INNER keyword).
Natural Join (Equality) : NATURAL JOIN keyword.
Cross-Join or Cartesian Product (No join condition):
Traditional comma-separated with the missing join condition
in the WHERE clause or CROSS JOIN keyword.
Self-Join (Equality): Equijoin or Inner Join.
Outer Join (left, right, full):(Equality and extending the
result set): "Complex Joins" OUTER JOIN keywords or outer
join operator(+).
Non-Equijoin (Nonequality of values): "Complex Joins"
Traditional comma-separated join or ANSI join syntax with
the ON clause.
The join criteria is not based on equality.
| Is This Answer Correct ? | 38 Yes | 33 No |
Post New Answer View All Answers
What is the security principal at the database level that represents your session?
Do you know what are pages and extents? : SQL Server Architecture
What is normalization and its types?
Explain user defined functions?
How to create user defined functions with parameters?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What are the differences between sql server and mysql.
How to drop existing indexes in ms sql server?
How to create a view using data from another view?
What is the difference between web edition and business edition?
What is the New in SQL server 2008?
Explain the use of keyword with encryption. Create a store procedure with encryption?
difference between Clustered index and non clustered index ?
how can a database be repaired? : Sql server administration
