>Terry,
>
>Can you keep separate table specificly for mapinfo with last revisions only or it's too dynamic?

Not sure what you mean. I have separate versions of my VFP tables, which I mutually update after changes in the VFP database or MI database end. Besides, MI only accepts dBASE tables, so I have to have, say, decimal 11,0 for VFP7 integer fields. So I have 2 complete copies of the database tables, one for each app.

So what's your drift, Sergey?
>
>>
>>>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
>>