>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.
< big shiver > boy that brings back some ugly SQL flashbacks from the dos dark ages of fox! =D)
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos