I've run into a situation using Dynamic SQL in an RPG program where I'd like
to be able to merge data from two files prior to running an SQL statement,
or merge the results sets from separate SQL statements if that is needed.

This isn't a join, it's two files with identical layouts, but different
field names and different category of data. Otherwise the files are

When a user does a search, they can search file A, file B, or both. So I'd
like to try to write this dynamic enough so all I do is check the search
flags they set and build my SQL appropriatly. Especially when they search
both so it will "mesh" the data from the two files in the result set.

Like I said, both files are exactly the same layout, just different field


Bradley V. Stone
BVSTools - www.bvstools.com
eRPG SDK - www.erpgsdk.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].