Results 1 to 2 of 2

Thread: Combining selects...

  1. #1
    Join Date
    Jun 2007
    Posts
    3

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Don't cross post.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •