>Changing JOIN will affect the result.
>With LEFT JOIN you will get all records from Main table and only matching records from joined table
>With simple JOIN (default is INNER) you get ONLY these records from main table that have coresponding records in second i.e.:

Just what I had worried about. The VFP equivalant of this is doing a FROM and WHERE on the table and SPT#1 cursor. Now the WHERE I have converted to JOIN () ON. What could have the VFP equivalant SQL with a WHERE clause return? ie. a result similar to JOIN or LEFT JOIN?