Join a SQL Server "joins type" - for Newbie
Since the beginning of learning SQL Server I'm pretty much confused with JOIN conditions that defines the way two tables are related in a query by:
- Specifying the column from each table to be used for the join. A typical join condition specifies a foreign key from one table and its associated key in the other table.
- Specifying a logical operator (for example, = or <>,) to be used in comparing values from the columns.
Though going by BOL gives much a thought but still there needs to be a better explanation, here are few MSDN blogs I would like to share from my library:
Nested Loop Joins Dissected
Merge Joins Dissected
Hash Joins Dissected
Summary of Join Properties
Overview of Logical Join Types (Inner/Outer/Cross/Semi/Anti-Semi/Cross Apply)
Comments
Anonymous comments are disabled
About SQL Master
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.