Hey Brian,

>Does anyone know of a good reference document or article on ANSI SQL-92, particularly using the JOIN statement in SELECTs ? Most FoxPro -related articles seem to focus on creating joins using WHERE statements, which was pre-VFP5. Joins on multiple tables, is the area I'd like to get a bit clearer on.

Have you looked at the code that the VFP Query Designer generates? When you specify Left or Right joins it uses the LEFT OUTER JOIN ON syntax. It'll get you started with understanding how to code outer joins.

Good luck!