Come on; such simple solutions are expected out of novice heads me not brilliant minds like you .... 🙂

Changing compatibility is not an option in most cases especially when you are housing a pure 80 DB with 80 specific query constructs or features that are deprecated in 90. Another way to workaround is to create a new DB with compatibility set to 90 and cross query the 80 database.