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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.