Hi,
Try the following query probably will work for you,
[code=sql]
SELECT
D_D.DEAL_ID, D_D.CURRENCY_CODE,D_D.RATE,
D_D.CURRENCY_AMOUT,D_D.SETTLEMENT_ AMOUNT,
convert(varchar , D_D.CREATED_DATE , 120) CREATED_DATE ,
CUSTOMER.COMPANY_NAME,PAYMENT_FUNDS_IN.AMOUNT,
(select sum(amount)as total
from PAYMENT_FUNDS_IN ,
DEAL_DETAIL
where DEAL_DETAIL.DEAL_ID=PAYMENT_FUNDS_IN.DEAL_ID AND
DEAL_DETAIL.CURRENCY_CODE = D_D.CURRENCY_CODE )
FROM DEAL_DETAIL as D_D,CUSTOMER ,PAYMENT_FUNDS_IN
where D_D.CUSTOMER_ID=CUSTOMER.CUSTOMER_ID AND D_D.DEAL_ID=PAYMENT_FUNDS_IN.DEAL_ID
[/sql]
Thanks
|