admin
05-30-2003, 01:53 PM
Using INNER JOINS:
An INNER JOIN is a join in which the values in the columns being joined are compared using a comparison operator. INNER JOINS can be specified in either the FROM or WHERE clause.
Using OUTER JOINS:
The LEFT JOIN operation creates a LEFT OUTER JOIN. LEFT OUTER JOINS include all of the records from the first (left) of two tables, even if there are no matching values for records in the second (right) table.
The RIGHT JOIN operation creates a RIGHT OUTER JOIN. RIGHT OUTER JOINS include all of the records from the second (right) of two tables, even if there are no matching values for records in the first (left) table.
Source: MSDN Library
An INNER JOIN is a join in which the values in the columns being joined are compared using a comparison operator. INNER JOINS can be specified in either the FROM or WHERE clause.
Using OUTER JOINS:
The LEFT JOIN operation creates a LEFT OUTER JOIN. LEFT OUTER JOINS include all of the records from the first (left) of two tables, even if there are no matching values for records in the second (right) table.
The RIGHT JOIN operation creates a RIGHT OUTER JOIN. RIGHT OUTER JOINS include all of the records from the second (right) of two tables, even if there are no matching values for records in the first (left) table.
Source: MSDN Library