>>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?
When you use WHERE for joining tables it is equivalent of [INNER] JOIN
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.