RE: SQL table joins: Join vs. Where

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx / Vern Hamberg
> Sent: Wednesday, August 11, 2004 6:12 PM
>
> The information on QRYDFN conversion is in chapter 12 of the V5R2 Query
> Management Programming manual. A search on QRYDFN might be more
> fruitful, too.

Oh, I thought you were pointing me to a discussion of a T01 <-- T02 <-- T03
multiple joins.  OK, I see the section on conversion.  It's apparent that
the conversion is pretty basic, eh?

> You have "AMFLIB/CIVSPCL0 T02" specified twice. The second one follows a
> comma, which is also invalid.
>
> JOINs are cumulative. Each JOIN works against the result of the previous
> JOIN. So the columns you want for the JOIN to T03 are there from the
> previous set of JOINs. Try this:

YESSSSSSS!  That was it!  Although, I admit to being confused by the syntax.
How does the SQL processor know to join T03 to T02 and not to the others?
Is it the field matching referring to T03 & T02 fields in the "on ("
section?  Or does this get more into the black box magic of SQL and most of
the time I won't care how it does it, it just does?

Thanks Vern!

db