>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