Terry,
Can you keep separate table specificly for mapinfo with last revisions only or it's too dynamic?
>
>>I agree with Cetin, it cannot be done with one query w/o subqueries.
>
>I'd kinda come to that conclusion myself last week after tearing my hair out for 2 days. I was just hoping that soemone more au fait with (basic) SQL might have an idea. I think I'll need to do it in code with do loops. What a pain!
>
>Thanks again for your efforts and trouble
>
--sb--