>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,
Ken,
There is no one rule I know of. However since you're talking about SQL server too I would bet for Method 2 if generally speaking. Apart from reasons you wrote SQL server might choose to make it like 'where key = key' or one of other methods depending on cost analysis.
I think you already answered yourself :)
Cetin