Yes providing both tables have either a common and unique (no duplicates) field to join on, such as an ID field or, the attributes in both tables share a common geographic object. Us the update wizard under the Table Menu, and under the Join button you will use one of the above 2 types of joins.
If there is no unique field then you maybe able to add one in IF you can go back to the step where table B was queried out of table A (you say B is a sub set of A). Before re creating the sub set operation, add in an ID field, populate it ROWID. To do that use the update wizard, field to update is ID and simply type ROWID in value box. Now create the subset table B then you can update A from B using ID as the join field. William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 - FAX (989) 773 1988 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: John Nott [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 4:11 AM To: [email protected] Subject: MI - L Joining Two Overlapping Tables Hello List, I have two tables A and B. table A contains rows with certain attributes and Table B contains rows with different attributes. Table B is a subset of table A and what I would like to do is add the attributes of table B to some of the rows of table A if you know what I mean. So I would like to keep all rows in Table A but add additional attributes (from B) to them. Sorry to be so confusing!!!! - is this possible???? Thanks, - John John Nott Consultant/GIS Analyst ROGER TYM & PARTNERS Fairfax House, 15 Fulwood Place, London, WC1V 6HU t 020 7831 2711 f 020 7831 7653 e [EMAIL PROTECTED] w www.tymconsult.com The information in this email is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely upon the information contained in this email. Such unauthorised use may be unlawful. If you have received this email in error, please reply immediately to this effect and delete it (and all copies) from your system (with thanks). This message and any attached files have been scanned for the presence of computer viruses. However, you are advised that you open any attachment at your own risk. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16683
