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
- 63799 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 happens if you add a new index to large table?
What is wide table?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
what is the difference between a primary key and a unique key? : Sql server database administration
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is a result set object returned by odbc_exec()?
Can sql server be linked with other servers like oracle?
Is resultset an interface?
What is a data collection table?
What is the name of reporting services config file and what’s it’s used for?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is a DBMS, query, SQL?
How do I perform an unattended install of sql server 2000?
Does group by or order by come first?
Difference between Sql server reporting services and Crystal reports?
