Does mapinfo need access to the previous genaerations of routes or only to the latest one?


>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
>>>