SELECT o.date dates,sum(o.sum) my_sum;
FROM abonfl_lic a, oplatfl o
WHERE a.schet= o.schet;
AND a.filter_uch= 1 ;
AND o.type =.t.;
AND o.date_month= 37 ;
GROUP BY o.date;
INTO CURSOR Cursor1

SELECT o.date dates,sum(o.sum) my_sum;
FROM abonfl_lic a JOIN oplatfl o
ON a.schet= o.schet;
AND a.filter_uch= 1 ;
AND o.type =.t.;
AND o.date_month= 37 ;
GROUP BY o.date;
INTO CURSOR Cursor1

SELECT o.date dates ,sum(o.sum) my_sum;
FROM  oplatfl o
WHERE  o.type =.t. AND date_month= 37 ;
AND chet IN (SELECT chet FROM abonfl_lic WHERE filter_uch= 1 )
GROUP BY o.date;
INTO CURSOR My_Cursor2

rock-n-roll,

CREATE CURSOR tab1(schet int,day_first int,day_last int,allpl int)
INSERT INTO tab1 values( 10000 ,  1 ,  6 ,  1 )
INSERT INTO tab1 values( 10000 ,  7 ,  18 ,  2 )
INSERT INTO tab1 values( 10000 ,  19 ,  31 ,  3 )
INSERT INTO tab1 values( 10001 ,  1 ,  6 ,  5 )
INSERT INTO tab1 values( 10001 ,  7 ,  18 ,  7 )
INSERT INTO tab1 values( 10001 ,  19 ,  28 ,  9 )

CREATE CURSOR c_days(days int,znach int)
FOR i= 1  TO  31 
INSERT INTO c_days values(i, 1 )
endfor

SELECT schet,days,allpl,znach;
FROM tab1 a,c_days b;
WHERE BETWEEN(b.days,day_first,day_last) and;
days <= all (SELECT MAX(day_last) mx FROM tab1 WHERE schet=a.schet GROUP BY schet);
order BY schet,days

SELECT schet,days,allpl,znach;
FROM tab1 a,c_days b;
WHERE BETWEEN(b.days,day_first,day_last);
order BY schet,days