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

The second method is better for SQL Server. There are a few join options that are available in SQL Server that require the second method. Besides, any outer joins in VFP require the second method so you may as well use it all the time.

- Keith