Re: Need to combine two queries

Marco wrote:

> Hi, I need two combine these two quieries but I am havin a difficult
> time trying to do so.
>
> Select SUM ( AMOUNT ) AMOUNT, OPT_NUM from MARCO2.esp_transactions
> where EXISTS ( SELECT optionee.OPT_NUM FROM MARCO2.optionee WHERE
> esp_transactions.OPT_NUM = 1 AND optionee.OPT_NUM =
> esp_transactions.OPT_NUM ) AND TRANS_TYPE >= 256 AND OFFER_NUM =
> 1 group by OPT_NUM
>
> Select SUM ( AMOUNT ) AMOUNT, OPT_NUM from MARCO2.esp_transactions
> where EXISTS ( SELECT optionee.OPT_NUM FROM MARCO2.optionee WHERE
> esp_transactions.OPT_NUM = 1 AND optionee.OPT_NUM =
> esp_transactions.OPT_NUM ) AND TRANS_DT <= '2001-07-09' AND
> TRANS_TYPE < 256 AND OFFER_NUM = 1 group by OPT_NUM
>
>
> Any ideas?
>

hi,

try
> Select SUM ( AMOUNT ) AMOUNT, OPT_NUM from MARCO2.esp_transactions
> where EXISTS ( SELECT optionee.OPT_NUM FROM MARCO2.optionee WHERE
> esp_transactions.OPT_NUM = 1 AND optionee.OPT_NUM =
> esp_transactions.OPT_NUM ) AND TRANS_TYPE >= 256 AND OFFER_NUM =
> 1 group by OPT_NUM
 UNION
> Select SUM ( AMOUNT ) AMOUNT, OPT_NUM from MARCO2.esp_transactions
> where EXISTS ( SELECT optionee.OPT_NUM FROM MARCO2.optionee WHERE
> esp_transactions.OPT_NUM = 1 AND optionee.OPT_NUM =
> esp_transactions.OPT_NUM ) AND TRANS_DT <= '2001-07-09' AND
> TRANS_TYPE < 256 AND OFFER_NUM = 1 group by OPT_NUM
;

it should work with your query

regards

Dietmar Received on Tue Jul 10 2001 - 16:44:49 CEST