>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