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
>