[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Adam Glauser
Sent: Thursday, March 13, 2008 1:32 PM
Subject: Re: SQL Question - Merging files or result sets?
Bradley V. Stone wrote:
This isn't a join, it's two files with identical layouts, but differentboth. So I'd
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
like to try to write this dynamic enough so all I do is check the searchthey search
flags they set and build my SQL appropriatly. Especially when
both so it will "mesh" the data from the two files in the result set.
I think that UNION will do the trick. Perhaps you could do
selectA = 'SELECT <the fields> FROM fileA WHERE <criteria>'
selectB = 'SELECT <the fields> FROM fileB WHERE <criteria>'
order = ' ORDER BY <ordering fields>'
if (search = both A and B)
query = selectA + ' UNION ' + selectB + order
elseif (search = A only)
query = selectA + order
query = selectB + order
Would something like that do what you're after?
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives