Export (0) Print Expand All 25 out of 46 rated this helpful -
Rate this topic  Join Fundamentals  SQL Server 2000  By using
joins, you can retrieve data from two or more tables based on
logical relationships between the tables. Joins indicate how
Microsoft® SQL Server™ 2000 should use data from one table to
select the rows in another table.  A join condition 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 (=, <>, and so on) to be used in comparing values from
the columns.  Joins can be specified in either the FROM or WHERE
clauses. The join conditions combine with the WHERE and HAVING
search conditions to control the rows that are selected from the
base tables referenced in the FROM clause.  Specifying the join
conditions in the FROM clause helps separate them from any other
search conditions that