Hi!

If used SQL how BD with SqlExec() function, you can do Left Join in 1st case thus:

SELECT field1, field2, field3 FROM table1, table2 ;
WHERE table1.field1 *= table2.field1

Bye!

>The 2nd version (using the JOIN syntax) is preferred as it allows things >like LEFT OUTER JOINS.

>>When I first learned SQL syntax, I wrote my own selects like
>>
>>SELECT field1, field2, field3 FROM table1, table2 WHERE table1.field1 = table2.field1
>>
>>Now, I'm using VFP 7/8 View Designer, and their format for the same would be
>>
>>SELECT field1, field2, field3 FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1
>>
>>So, I'm wondering what/why the difference is between the statements.
>>
>>Chris.