hi all,

i need help to get records from table a1 and table(mas.ncount)
table a1(
column3
1 = 11450 records
2 = 3700 records
3
4
.
.
******************

table mas(
column3,ncount
1 2333
2 1340
3 750
4 100
5 340
6 .
7 .
8
9
10
13
16
17
19
20
40
41
42
43 270
***********************************

i want to create new cursore have
column3
1= 2333 records
2=1340 records

i try as below not works as i want

SELECT  TAlias1.no,TAlias1.column3,TAlias1.sum1,TAlias1.total,TAlias2.ncount;
              FROM a1 TAlias1, mas TAlias2 ;
       WHERE  TAlias1.column3= TAlias2.column3 AND RECNO()<=TAlias2.ncount ;
        nofilter;
        INTO cursor TAliascursor1

thanks