>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.
>
While FPDOS supported SQL Slect statements, it did not support as much of the syntax as VFP did, and different versions of FPDOS supported different subsets (the later the version, the more of the total syntax was supported.)
The INNER/OUTER JOIN constructs specifically were not supported in FPDOS; you would have to write the join conditions into the WHERE clause, and for OUTER JOINs, you'll either need to merge the results of multipel Select statements, or use the UNION clause to concatenate multiple Selects within a single statement.