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