Tony,
the way that I would go is a SQL query joined on the ID, with the
properties table listed first in the From clause. This will return the
property regions together with all required attribute data.
Cheers,
Andreas
.
Andreas Mahn
dds GmbH
Stumpfstr.1
76131 Karlsruhe
Germany
Tel.: +49 - (0)721 - 9651406
Fax: +49 - (0)721 - 9651419
http://www.dds.ptv.de/
...
[EMAIL PROTECTED]
>--
>Von: Tony Shepherd[SMTP:[EMAIL PROTECTED]]
>Gesendet: Donnerstag, 1. Juli 1999 01:14
>An:MapInfo Email Group (E-mail)
>Betreff: MI Table update column command
>
>Using the "update column" command off the table menu can you add a
>temporary column that is a object from another table.
>For example I have a table of properties, with a region and a property
>ID. I have another table with names of people and a property ID. I want
>to copy all the objects from the property table to my names table only
>where there is a match between property ID's.
>I have written MapBasic code to do this but I am curious if it can be
>done straight from MI?
>Cheers
>Tony
>
>- - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Tony Shepherd, GIS / IT Support
>Gore District Council, Gore, New Zealand
>Gore, The Brown Trout Capital
>
> .. .. .. .. check it out! .. .. .. ..
> .. . www.mataura.com . ..
>- - - - - - - - - - - - - - - - - - - - - - - - - - -
>
>--
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]