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
>>
If it's not broken, fix it until it is.
My Blog