Merge two query results

[Guest]

Is it possible to merge 2 query results?

I have a function that returns a querey result.

< CFSET temp = query1>
<CFSET FNCTransfers = temp>

Now I want to change the query to return a merged query result

< CFSET temp = query1>
<CFSET temp2 = query2>

Is it possible to merge the two results?

Some thing like this (I know that it cannot be done like this)
<CFSET FNCTransfers = temp1 & temp2>

Maby it should be a union and query of query?

[Guest]

You will most likely find trying to use Query of Query very problematic. I reccommend that you actually write a SQL statement to do the union at the DB end.

I know that it seems a bit crappy, but i think it will help you maintain your sanity.

[Dan_Bracuk]

The best way to achieve your goal depends on what it is. Your question is very general.

[Newsgroup_User · Accepted solution]

UNION could be the way to go. the query results will have to match up
between the 2 queries (field data types need to match for both queries)

<cfquery name="qryMergedQueries" dbtype="query">
SELECT * FROM query1
UNION
SELECT * FROM query2
</cfquery>


kruse wrote:
> Is it possible to merge 2 query results?
>
> I have a function that returns a querey result.
>
> < CFSET temp = query1>
> <CFSET FNCTransfers = temp>
>
> Now I want to change the query to return a merged query result
>
> < CFSET temp = query1>
> <CFSET temp2 = query2>
>
> Is it possible to merge the two results?
>
> Some thing like this (I know that it cannot be done like this)
> <CFSET FNCTransfers = temp1 & temp2>
>
> Maby it should be a union and query of query?
>

[Guest]

I had two different queryes getting internal transgers in a company and external transfers in/out of a company and then I would show a merged list of this two results.
The two queryes vere very complex and therfore I would not merge the two queryes into one query.

The query of query aproach worked very well.

[Ramil5CF0]

Merging pag.ibig contribution