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
- 63363 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 new philosophy for database devises for sql server 7.0? : Sql server database administration
Define tempdb database?
How do I open port 1433?
What are transactions in sql?
Explain the database you used in your final year project?
List down some advantages of sql stored procedure?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How to backup SQL Server Reporting Services ?
Explain about service Broker functions?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are the advantages of passing name-value pairs as parameters?
What is the default value of an integer data type in sql server 2005?
What is use of dbcc commands?
What are the disadvantages of using the stored procedures?
What is a DBMS, query, SQL?
