-
Combining selects...
#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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|