Files

7 lines
282 B
SQL

select sum(credito) from cptb00003 where cuenta_no = "2113" and
fecha between "010499" and "300499" and status_t is null and
cod_sp = 23 ;
select sum(valor) from cptb00001 where cod_sp = 23 and
tipo_doc = "FT" and status_t is null and
fecha_orig between "010499" and "300499"