>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