Skip to main content
A
Anonymous
November 14, 2006
Answered

Merge two query results

  • November 14, 2006
  • 5 replies
  • 880 views
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?


This topic has been closed for replies.
Correct answer Newsgroup_User
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?
>

5 replies

R
Ramil5CF0
Participant
September 27, 2021

Merging pag.ibig contribution

A
Anonymous
November 15, 2006
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.
N
Newsgroup_UserCorrect answer
Inspiring
November 14, 2006
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?
>
D
Dan_Bracuk
Inspiring
November 14, 2006
The best way to achieve your goal depends on what it is. Your question is very general.
A
Anonymous
November 14, 2006
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices