>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 >>
>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') >>