I am far from a good VFP programmer, but I have seen that error before. I believe what i did to "work around" it was to break it into 2 select statements (or more if necessary) and then combine the results. I would select and get maybe 1/2 of the results into a cursor, then get the other 1/2 into another cursor, and then select all from both cursors. I cannot speak technically about it, but my select statement that gave the same error was extremely long and I guess foxpro didn't like that.:-)

hope this helps. as i said i am not great with it but i have been able to do work arounds before.

paul