>>>>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)
>>
>>Aw, come on Rox!! I wouldn't exactly call it the dark ages!! Back then, Fox was the hottest thing going!! Ya gotta keep that in perspective!
>
><g> yeah I know, but I got stuck in the 2.6 time warp with legacy apps for the first 2 years of the VFP era... so I'm a little more scarred than most =D)

I'm still working in FPD2.6a... feels like when I was teaching maths, and first grade (high school) kids come up with some problem... I know how to solve it easily, but they haven't learned that yet... so what was the workaround...

I've got that lazy that I hate it to have to manually strip the final backslash from curd() - can't use set("directory") in FPD, grrrrr.