thank you,
erro message
Unrecognized command verb
INTO cursor TAliascursor1 nofilter

>>thank you,
>>i have no idea for that
>>>I see. In this case I suggest to forget about doing it using select and use procedural code to generate needed number of entries.
>>>
>>>>sorry for that, but still
>>>>File "name" is too large (Error 1190)
>>>>>You're missing FROM , e.g.
>>>>>

>>>>>select Numbers.Number, X.* from Numbers ;
>>>>>INNER JOIN (...) X ;
>>>>>ON ...

>>>>>
>
>

>SELECT  TAlias1.no,TAlias1.column3,TAlias1.sum1,TAlias1.total,TAlias2.ncount;
>              FROM a1 TAlias1, mas TAlias2 ;
>       WHERE  TAlias1.column3= TAlias2.column3 
>        INTO cursor TAliascursor1 nofilter
>
>select * from tAliasCursor1 where 1= 0 into curFinalResult readwrite
>
>select tAliasCursor1
>scan
> scatter memvar
>  for i=1 to nCount
>     insert into curFinalResult from memvar
>  next
>endscan
>
>select curFinalResult
>browse