At 07:46 PM 27/02/2004 +0000, you wrote:

>Hi, Terry.
>
>* You should use INNER JOIN to include only the records of the MINERS
>table that have a correspondence with the records of the view.
>
>* You should use LEFT OUTER JOIN (use the three words) to include all
>the records of MINERS, including those that do not have a
>correspondence with the records in the view.

Not true. OUTER is optional. LEFT JOIN and LEFT OUTER JOIN mean exactly
the same.

/heLen