Yes, you are correct. I meant Non-Ansi style joins. 😉

In the recent upgrade at our organization, we actually had a few of these JOINs. A few years ago, with a 2000 to 2005 upgrade, I ran into the same problem as well. Like your situation, the databases were actually designed by third-parties.

In the recent upgrade to 2K8, we did experience a few more minor problems which were discovered during testing that the Upgrade Advisor did not detect. However, these few problems were handled within a day or two. Just wanted to send the friendly reminder to thoroughly test beforehand.