Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). Using SQL Server Joins   Article Abstract: In this article, Alexander Chigrik presents a detailed SQL Server Joins guide as well as tips for optimizing joins and troubleshooting join problems.   Read this article...

Related Articles - For Members. All Articles By Author Displaying XML data in HTML files Oracle 2-Day DBA in x Days Post 9; Oracle Automatic Memory Management Changing from Non-IDENTITY to IDENTITY and vice versa Oracle 2-Day DBA in x Days Post 6; Understanding Oracle's Networking Environment Prioritize your Work Load (Finding Low Hanging Fruit) Deciphering the difference between different Ranking Functions in SQL SERVER 2005. Calling stored procedures on Oracle from MS SQL 2000 Generate Next Numbers with SQLServer Load Impact of SQL Profiler 2000

RE: Using SQL Server Joins
(posted: 10/11/2005 6:40:09 AM)
You really need to get an editor. The grammar of the article made it very difficult to read, and in some places it was incomprehensible

RE: Using SQL Server Joins
by Karen Edwards (posted: 1/22/2008 10:52:49 PM)
Good information for a beginner/intermediate level. Most beginners would just depend on the query optimizer. However, once past that stage, when they are ready to learn more, this is a useful explanation of the various types of joins.