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 ...
>
>>thank you,
>>error message Command contains unrecognized phrase/keyword
>>
>>at first line
>>select Numbers.Number, X.* INNER JOIN (SELECT TAlias1.no,TAlias1.column3,TAlias1.sum1,TAlias1.total,TAlias2.ncount;
>> FROM a1 TAlias1 INNER JOIN mas TAlias2 ;
>> ON TAlias1.column3= TAlias2.column3) X ;
>>ON X.nCount >= Numbers.Number
>>
>>Command contains unrecognized phrase/keyword
>>>>thank you fro reply,
>>>>i do it, it is slow and message no space at c: but i have space at c:\
>>>>
>>>
>>>Try
>>>
>>>select Numbers.Number, X.* FROM Numbers INNER JOIN (SELECT TAlias1.no,TAlias1.column3,TAlias1.sum1,TAlias1.total,TAlias2.ncount;
>>> FROM a1 TAlias1 INNER JOIN mas TAlias2 ON TAlias1.column3= TAlias2.column3) X
>>>ON X.nCount >= Numbers.Number
>>>