>DECLARE @NoMember Integer >DECLARE @LastAccess DateTime > >SET @NoMember=64631 >SET @LastAccess='2009-02-11 11:46:55' > >SELECT Member.Numero,Member.Nom,Member.Prenom,Member.LastAccess > FROM (SELECT Monitor.NoMember2 FROM Monitor WHERE Monitor.NoMember=@NoMember) Temp > INNER JOIN Member ON Temp.NoMember2=Member.Numero > WHERE Member.LastAccess>=@LastAccess ORDER BY 2 >>