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
>>