>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
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.