>>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
Never tested it with "Blood and Sweat" but supposedly yes, because joinning is not the same as filtering a set of records. Anyway, Joins are the ANSI implementation of the SQL.
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line