The method I used to learn was to use the FoxPro Query designer to "prototype" my query, then look at the generated SQL using the "See SQL". Really helps when you use the not-used-too-often features of SQL like the "Group By" clause, or the "Having" clause, or "Union" and "Distinct".
DP
Live life today - tomorrow will take care of itself.
