thank you,
i have no idea for that
>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 ...
>>>