>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