Hi all,

opinions wanted on preferred join syntax. Do you prefer:

1) ... from t1, t2 where key = key
or
2) ... from t1 join t2 on key = key


is there any benefit to either method for VFP? - for SQL Server?

FWIW - I prefer method 2 for the following reasons:
- in multi-table joins - clear what is join and what is filter
- more readable in general
- since outer joins require method 2, I don't have to mix two different methods

Looking forward to your thoughts.

TIA,