>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

You can not use recno() in multi-tables query.
I suggest:

1. Create a Numbers table with Numbers from 1 to 100000 in a loop.

2. Change your query to

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