>>>Hi Kevin,
>>>
>>>to my low english:
>>>>going to pull out around 5 to 6 records
>>>
>>>means the result is 5 to 6 records (IOW _Tally=)?
>>>
>>>How many records are used to create those records? SELECT SQL generates temporary cursors within the select. If temp space is low it may fail. Remeber that WHERE / ORDER / GROUP and the like will happen after all joins are done.
>>
>>Well the strange thing is that it doesn't happen all the time, it's a simple select joining 2 tables.
>>
>>Kev
>
>The SQL will generate some temp cursor if you join two tables and use where or order. If it's larger then temp space it fails. The size of the temp location is not constant. A small change increase and there is not enough space. Simple clear unneded files from the temp location and try to reproduce.
>
>Agnes

Thanks, I'll give that a go.

Kev