RE: SQL table joins: Join vs. Where

Vern,

You're right.  Sorry about that Jay.  That's what I get for replying to
quickly.

Got mixed up between JOIN and INNER JOIN which is where the quote from the
manual comes in.  When doing left joins I always specify LEFT OUTER JOIN.



Charles


> -----Original Message-----
> From: Vern Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx]
> Sent: Monday, August 16, 2004 2:18 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: SQL table joins: Join vs. Where
> 
> 
> LEFT JOIN == LEFT OUTER JOIN, according to the SQL reference 
> manual. No 
> such thing as LEFT INNER JOIN.
> 
> The statement you gave is typical IBM gobbledy-gook It means 
> that if the 
> JOIN keyword is not qualified by one of the join operators 
> (none of which 
> have the word JOIN in them), then INNER is assumed. The 
> little diagram 
> helps, but this is not necessarily the simplest thing to wade through.
> 
> HTH
> 
> Vern
>