quote:

---

SELECT sum(i.Amount), sum(p.AMT_INVOICE)
FROM PJ_TRN_INV_PLAN AS p INNER JOIN
mst_Invoice AS i ON p.INVOICE_NO = i.Inv_No AND p.REV_HD_CODE = i.Revenue_code
WHERE (p.REV_HD_CODE = 'QMS SOUTH') AND (p.MONTH_CODE = 3) AND (p.YEAR_NO = 2009)

---

SELECT
    SUM(D2.ActualInvoiceAmount) AS ActualInvoiceAmount
    ,SUM(D1.PlanInvoiceAmount) AS PlanInvoiceAmount
FROM
(
    SELECT p.Invoice_NO
        ,P.Rev_HD_code
        ,SUM(p.AMT_INVOICE) AS PlanInvoiceAmount
    FROM PJ_TRN_INV_PLAN p
    WHERE p.REV_HD_CODE = 'QMS SOUTH'
        AND p.MONTH_CODE = 3
        AND p.YEAR_NO = 2009
    GROUP BY p.Invoice_NO
        ,P.Rev_HD_code
) D1
    JOIN
    (    
        SELECT i.Inv_No
            ,i.Revenue_code
            ,SUM(i.Amount) AS ActualInvoiceAmount
        FROM mst_Invoice i
        GROUP BY i.Inv_No
            ,i.Revenue_code
    ) D2
        ON D1.Invoice_NO = D2.i.Inv_No
            AND D1.Rev_HD_code = D2.Revenue_code