#1
Old Today, 04:32 AM
meehi meehi is offline
Registered User

Join Date: Jun 2007
Posts: 1
Combining selects...
Hi there I have been looking for help on this for a number of days. I have two separate queries which generate two separate sets of results. I need these to be combined into one query giving me the same results. This is for use in Report manager.

Query 1

SELECT CLID,BILLNAME,COUNT(BILLNAME),SUM(AMOUNT),
DIV(SUM(BILLSEC), 60) bmins, MOD(SUM(BILLSEC), 60) bsecs
FROM BILLTABLE_BILLING
Where (CALLDATE >= :START_DATE AND CALLDATE <= :END_DATE)
AND CLID <> '' AND BILLNAME <> '' AND AMOUNT <> 0
GROUP BY CLID,BILLNAME

Query 2

SELECT CLID, SUM(AMOUNT),COUNT(CLID),
DIV(SUM(BILLSEC), 60) bmins, MOD(SUM(BILLSEC), 60) bsecs
FROM BILLTABLE_BILLING
Where (CALLDATE >= :START_DATE AND CALLDATE <= :END_DATE)
AND CLID <> '' AND AMOUNT <> 0
GROUP BY CLID

Please help I'm getting desperate. Also does anybody have much experence using Report Manager?

Thanks
Craig