>Set Ansi On - shows the exact same things now in sys(3054) and works just as fast. > >Here is the link: >http://www.ms-news.net/f1342/strange-behaviour-when-joining-2-tables-10694727.html > >I actually remember this now. But it's been so long! > You're right, I think it was discussed here at some point also. Glad you found it.