>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
I meant it wouldn't work that way. There is a hypen in your first alias which would confuse VFP. Doesn't it ask for a file if you make it:
select q.* from qpl-all q
IMHO first correct it.
Cetin