Jim,
I don't know how much experience you have with the old Query/400 tool but,
if you have worked with it, sometimes I used the following example in some
of my SQL classes for RPG programmers:
SQL Join Qry/400 Option
(inner) join 1=Matched records
Left (outer) join 2=Matched records with primary file
Exception join 3=Unmatched records with primary file
The "Inner" and "outer" words are optional.
Regarding your ordering issue, I concur with Joe's post. ORDER by is
absolute. Would it be possible for you to post a "nearer to reality" code?
Also, I always like to refer to IBM's manuals (I am one of those weird
people who really like to read them). the PDF for Embedded SQL programming
can be found here:
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajp/rzajppdf.pdf?view=kc
Anyhow, as always, please don't hesitate to ask for any doubts you can have.
Best Regards,
Luis
Luis Rodriguez
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
