The most important thing to know about FoxPro's help on SQL, is that it really only gives you the valid syntax constructs for FP's limited implementation. While there are a few examples, you'll need a good SQL reference / tutorial to be able to take real advantage of the power that SQL offers.
Rick