>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.
>TIA, Brian
There is a tip in the VFUG site explaining what INNER and OUTER joins are and there are probably one or two on this site as well.
You also may want to check
www.itlibrary.com - it has a lot of books on-line
and probably have one or two that deal with SQL
Arnon