Interested to Buy Any Domain ? << Click Here >> for more details...
What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
- 9 Answers
- 63704 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 information that can be stored inside a bit column? : Sql server database administration
Tell me what do you understand by a view? What does the with check option clause for a view do?
Will count(column) include columns with null values in its count?
What is a fill factor?
Tell me what are the essential components of sql server service broker?
Where in ms sql server is ’100’ equal to ‘0’?
Please illustrate physical database architecture? : SQL Server Architecture
define and explain the differences between clustered and non-clustered indexes.
How to end a stored procedure properly in ms sql server?
How to throw custom exception in Stored Procedure?
What is exporting utility?
Explain log shipping and mention its advantages.
Can you explain different types of locks in sql server?
What does the on delete cascade option do?
Why do we backup Active Directory ?
