>>select MEMBER.PRENOM, MEMBER.NOM
>>From MEMBER Inner Join LISTSERV
>>On MEMBER.NUMERO = LISTSERV.NOMEMBER
>>Where LISTSERV.NOCLIENT = 5
>
>Ok, this is faster.
>
>Now, is the Inner Join faster than the following SQL?
>
>SELECT MEMBER.PRENOM,MEMBER.NOM FROM MEMBER,LISTSERV;
> WHERE LISTSERV.NOCLIENT=5 AND LISTSERV.NOMEMBER=MEMBER.NUMERO

Btw, I got this from the document "New Visual FoxPro 5.0 features":
"Use ANSI-compliant joins. In addition to being consistent with Microsoft Access, Microsoft SQL Server, and other American National Standards Institute–compliant (ANSI-compliant) approaches, this method yields faster results than its predecessor. For developers moving from previous versions, queries are automatically converted to the new syntax by the Query Designer. The Query Designer also creates ANSI-style joins by default, so developers can learn the new syntax as they build new queries."