>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