This is weird. The following returns 10 records:

SELECT Thread.Title,Thread.AddDate,Member.Prenom,Member.Nom,Category.Anglais,Thread.Numero,Thread.NoThread;
 FROM Temp0000015806223254185171000;
 INNER JOIN Thread ON Temp0000015806223254185171000.Numero=Thread.Numero;
 INNER JOIN Member ON Thread.NoMember=Member.Numero;
 INNER JOIN Category ON Thread.NoCat=Category.Numero

but the following returns 13 records:

SQLEXEC(lnHandle,'SELECT Thread.Title,Thread.AddDate,Member.Prenom,Member.Nom,Category.Anglais,Thread.Numero,Thread.NoThread '+;
 'FROM \\SERVER5\D$\iis\universa\VisualFoxPro\Temp\Temp0000015806223254185171000 '+;
 'INNER JOIN Thread ON Temp0000015806223254185171000.Numero=Thread.Numero '+;
 'INNER JOIN Member ON Thread.NoMember=Member.Numero '+;
 'INNER JOIN Category ON Thread.NoCat=Category.Numero')

It is the same SQL. What am I missing?