>DECLARE @NoMember Integer >DECLARE @LastAccess DateTime > >SET @NoMember=12985 >SET @LastAccess='2009-02-13 11:02:33' > >SELECT Member.Numero,Member.Nom,Member.Prenom,Member.LastAccess > FROM Member WITH (NOLOCK) > WHERE Member.LastAccess>=@LastAccess AND > EXISTS (SELECT 1 FROM Monitor WHERE Monitor.NoMember2=Member.Numero AND Monitor.NoMember=@NoMember) > ORDER BY 2The accuracy of the data has to be 100%. So, if NOLOCK could cause the data to not be accurate, I cannot use that approach.