Here's something you might try. I have no idea if this will work, but it might be worth a try.
Create a separate database that in Compat 90. Write the query in there, using 3-part names so it queries from the Compat 80 database. Then, in the Compat 80 database, write a query that selects from the Compat 90 database.
Might work, might not. Probably worth a try.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon