Adam Glauser had it right a few emails ago.
Select ...where
union all
select ...where
order by ...

"Bradley V. Stone" <bvstone@xxxxxxxxxxxx> 03/13/08 3:35 PM >>>

Yes, that looks like exactly what I want, except the ORDER by clause.

Basically what I want to do is:

select * from fileA where ....
select * from fileB where ....

Now, how do I order the unioned result set? If I use order by using fields
from fileA, will it mix in the fileB records as well?

Bradley V. Stone
BVSTools -

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Adam Glauser
Sent: Thursday, March 13, 2008 1:32 PM
To: midrange-l@xxxxxxxxxxxx
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 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.

I think that UNION will do the trick. Perhaps you could do
something like:

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)
mailing list
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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

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