>SELECT Member.Numero,Member.Nom,Member.Prenom,Member.LastAccess > FROM Member > JOIN Monitor ON Monitor.NoMember2=Member.Numero > WHERE Member.LastAccess >= @LastAccess > AND Monitor.NoMember = @NoMember > ORDER BY 2 >That's what I had at first but that one was not optimized. When I changed to select the record from Monitor first, I got an immediate result. I will try the EXISTS approach. Hopefully, this will resolve the issue.