SELECT f1, f2, f3 FROM table1 t1 LEFT JOIN table2 t2 ON t1.field1 = t2.field1

>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.