Re: next baby step in SQL: start using join

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Dan,

Be careful!  the rtvqmqry on a QRY400 object will not work in all
instances.  it will lose a lot in the translation if it has a join option 2
or 3.

i don't believe it will ever generate an INNER JOIN (join option 1),
EXCEPTION JOIN (join option 3) or a LEFT OUTER JOIN (join option 2).  it
only does a simple join (linked only by the where clause).  this is the
equivelent of an INNER JOIN.

these are the 3 basic join options:

INNER JOIN (include records from both files only if they match the ON
clause of the join.

LEFT OUTER JOIN (include ALL records from the first file (predicated on
WHERE clause) and only those records from the second file that match the ON
clause.

EXCEPTION JOIN (include only those records from the first file that don't
have a match in the second file, based on the ON clause.

after you've mastered the two-file join, it's time to mix and match more
than 2 files with different join options!

the fun never ends!

hth,

Rick

----original message------
dan said:
<snip>
So, I am surprised to see that the generated SQL doesn't have any Join
clauses (?) but, instead,
does the join via WHERE, i.e.:
<more snip>