SQL & PL/SQL

hi

i have this query with me ,i require require sum(ai. INVOICE_AMOUNT ),sum(ai. AMOUNT_PAID)

SELECT TRUNC (ai.gl_date), gcc.segment1, gcc.segment2,
       aca.amount paymentamount, aca.vendor_name suppliername,
       aca.check_date paymentdate, ai.invoice_num, ai.invoice_currency_code,
       aipa.accounting_date, aipa.invoice_id, ai.vendor_id, ai.amount_paid,
       ai.invoice_amount, ai.invoice_date, ai.invoice_type_lookup_code,
       pv.vendor_name
  FROM ap_invoices_all ai,
       po_vendors pv,
       ap_invoice_payments_all aipa,
       ap_checks_all aca,
       gl_code_combinations gcc
 WHERE ai.vendor_id = pv.vendor_id
   AND aca.vendor_id = ai.vendor_id
   AND aipa.check_id = aca.check_id
   AND aipa.invoice_id = ai.invoice_id
   AND ai.accts_pay_code_combination_id = gcc.code_combination_id and aipa.check_id=aca.check_id
			and aipa.invoice_id=ai.invoice_id
			and ai.ACCTS_PAY_CODE_COMBINATION_ID=gcc.CODE_COMBINATION_ID

i require sum(ai. INVOICE_AMOUNT ),sum(ai. AMOUNT_PAID)
i tried

SELECT   TRUNC (ai.gl_date), gcc.segment1, gcc.segment2,
         aca.amount paymentamount, aca.vendor_name suppliername,
         aca.check_date paymentdate, ai.invoice_num, ai.invoice_currency_code,
         aipa.accounting_date, aipa.invoice_id, ai.vendor_id, ai.amount_paid,
         ai.invoice_amount, ai.invoice_date, ai.invoice_type_lookup_code,
         pv.vendor_name, SUM (ai.invoice_amount), SUM (ai.amount_paid)
    FROM ap_invoices_all ai,
         po_vendors pv,
         ap_invoice_payments_all aipa,
         ap_checks_all aca,
         gl_code_combinations gcc
   WHERE ai.vendor_id = pv.vendor_id
     AND aca.vendor_id = ai.vendor_id
     AND aipa.check_id = aca.check_id
     AND aipa.invoice_id = ai.invoice_id
     AND ai.accts_pay_code_combination_id = gcc.code_combination_id
GROUP BY TRUNC (ai.gl_date),
         gcc.segment1,
         gcc.segment2,
         aca.amount,
         aca.vendor_name,
         aca.check_date,
         ai.invoice_num,
         ai.invoice_currency_code,
         aipa.accounting_date,
         aipa.invoice_id,
         ai.vendor_id,
         ai.invoice_date,
         ai.invoice_type_lookup_code,
         pv.vendor_name,
         ai.amount_paid,
         ai.invoice_amount

but since in the group by all fields are taken the proper sum doesnt come

the output comes as follows

amount paid invoice amount  sum(amountpaid) sum (invoice amount)
75                87                         75                       87
89                100                      89                      100

kindly help

Edited by: makdutakdu on Oct 17, 2010 3:09 PM

Edited by: makdutakdu on Oct 17, 2010 3:29 PM