SQL UNION sounds like a perfect fit. The first select in the union will
determine the resulting column name for the result set.
Select field1a as firstfield, field1b as secondfield from file1
Select field2a, field2b from file2
TS Water Valley
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bradley V. Stone
Sent: Thursday, March 13, 2008 13:22
Subject: SQL Question - Merging files or result sets?
I've run into a situation using Dynamic SQL in an RPG program where I'd
to be able to merge data from two files prior to running an SQL
or merge the results sets from separate SQL statements if that is
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
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
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
Bradley V. Stone
BVSTools - www.bvstools.com
eRPG SDK - www.erpgsdk.com
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