sql query/CR XI

[syncdba]

Hi,
I was using 2 SQl Queries with UNION
SELECt id,accountid,closedate,closemonth,date from date1
UNION
SELECT id,accountid,closedate,closemonth,Month from month1

I have created this query to APPEND the two queries for dynamic parameter
Closemonth Date
08/01/2005 date Date date1(table)
Aug2005 Month Month Month(table)
09/01/2005 date date
Sept2005 month
10/01/2005 date
Oct2005 month
Then I have created a dynamic prompt on Date column which will ask user to select either "date" or "month".
This query is working fine but taking lot of time. Is there any way I can APPEND these column in CR formulas or anything else.

 

[syncdba]

Hi,
I'm SQL guy & new to CRXI. I'm using UNION on 2 queries to get dynamic prompt. can somebdy please tell me the foramt of UNION in CRXI.