Merhaba Cetin,
That is the code. Those are the constraints I was given to work with. I have some similar queries, and that is one of a few that gives me "The Invalid Seek Offest" Error on the networked version of VFP 9.0 and on my laptop I get the "Tmp file is too large" error.
I realize the SQL statement is not well written, I plan to incorporate the suggestions, but I am still getting the error even with the better written versions. I want to understand why I am getting the error. I appreciate all the comments on the code and plan to make the changes to make it better, but I need to resolve the error first.

Would making the swap file in MS Windows help? Is there a VFP 9.0 setting I could turn on t get the query to finish?
I am open to ideas.
thanks for everyone's help