I see. In this case I suggest to forget about doing it using select and use procedural code to generate needed number of entries.
>sorry for that, but still
>File "name" is too large (Error 1190)
>>You're missing FROM , e.g.
>>
>>select Numbers.Number, X.* from Numbers ;
>>INNER JOIN (...) X ;
>>ON ...
>>
If it's not broken, fix it until it is.
My Blog