Neither the foxpro or Visual Foxpro query tools are very extensive. I have heard that there are some 3rd party query tools.

http://www.get-ideas.com/qmf_main.htm
http://www.hallogram.com/qckqry/index.html
http://www.hallogram.com/foxfire/index.html

and some others
http://www.hallogram.com/menus/Query_Generators.html

I have never used any of these, so I don't know how good they are.

>Ok I am using Fox for DOS. I am using DOS because I am being forced to. Now what I want to know is: How do I write a query in SQL without using that stupid query wizard thing. It is more confusing that just writing the query in SQL. I have already written my SQL as a .prg and I don't think it recongnizes it as SQL code. So any help that anyone may have would be most appreciated.
>
>Thanks