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]