>>>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)