Consulta entre dos tablas

[triqui]

Bueno al final pude.


Pego la sql

Código SQL:

SELECT a.sk_dim_time
      , last_value(b.trqt_acum IGNORE NULLS) OVER (
           ORDER BY a.sk_dim_time
          ROWS BETWEEN unbounded preceding AND CURRENT ROW
         ) trqt
    FROM fact_cost a
    LEFT OUTER JOIN fact_stock_acum_temp_month b
      ON a.sk_dim_time = b.sk_dim_time
   ORDER BY a.sk_dim_time