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.