Hi!

It does not matter. VFP takes a join conditions from WHERE clause and try to optimize them by the same way as if you use INNER JOIN.

>Building some additional views for an application. Is it more efficient to have joins in views or to have WHERE ... AND clauses?
>
>For example,
>
> SELECT ..... ;
> FROM MyDbc!TableA ;
> INNER JOIN MyDbc!TableC ;
> ON MyDbc!TableA.nID = MyDbc!TableC.nID ;
> WHERE MyDbc!TableA.nID = ?vp_nID
>
>
>OR
>
> SELECT .... ;
> FROM MyDbc!TableA, MyDBc!TableC
> WHERE MyDbc!TableA.nID = MyDbc!TableC.nID ;
> AND MyDbc!TableA.nID = ? vp_nID
>
>I seem to remember reading somewhere that the joins are slower.
>
>Thanks
>
> Bob