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
Union all
Select field2a, field2b from file2

Loyd Goodbar
Senior programmer/analyst
BorgWarner
TS Water Valley
662-473-5713

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bradley V. Stone
Sent: Thursday, March 13, 2008 13:22
To: midrange-l@xxxxxxxxxxxx
Subject: SQL Question - Merging files or result sets?

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
identical.

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
names.

Thanks!

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


This thread ...

Replies:

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].