NRO_CONTA|COD_AGENCIA|NOME      |SALDO  |LIMITE|ENDERECO|DDD_FONE|
---------|-----------|----------|-------|------|--------|--------|
    30001|         30|ANA TERESA|   1000|   500|        |        |
    30002|         30|CAROLINA  |   5500|  2500|        |        |
    30003|         30|JOAQUIM   |    800|     0|        |        |

NRO_CONTA|DATA_APLIC         |COD_FUNDO|NRO_COTAS |VLR_APLIC|
    ---------|-------------------|---------|----------|---------|
        30007|2010-01-04 00:00:00|        1|999.430325|     1000|
        45004|2010-01-04 00:00:00|        1|749.572744|      750|
        30002|2010-01-04 00:00:00|        2|999.350422|     1000|

COD_FUNDO|DATA_COTA          |VALOR_COTA|
---------|-------------------|----------|
        1|2010-01-01 00:00:00|         1|
        2|2010-01-01 00:00:00|         1|
        3|2010-01-01 00:00:00|         1|

SELECT C.NRO_CONTA, C.NOME, C.SALDO ,
       ROUND(SUM(FA.COTAS * FA.VALOR_COTA),2) AS SALDO_APLIC
FROM CONTA C
  JOIN (
    SELECT FA.NRO_CONTA , FA.COD_FUNDO, FA.NRO_COTAS AS COTAS , DC.VALOR_COTA AS VALOR_COTA
    FROM FUNDOS_APLIC FA
    JOIN (SELECT COD_FUNDO, MAX(DATA_COTA) AS DATA_COTA , VALOR_COTA FROM FUNDOS_COTA GROUP BY COD_FUNDO) DC ON FA.COD_FUNDO = DC.COD_FUNDO
    GROUP BY FA.COD_FUNDO, FA.NRO_CONTA
  )FA  ON C.NRO_CONTA = FA.NRO_CONTA