Hi Robert, Assuming that you are trying to update empty cells in one table (e.g. Table_1), with information from another (e.g. Table_2), you could process a SQL query and select all empty records from Last_Column in Table_1:
Select: * From: Table_1 Where: Last_Column like "" Order By: Group By: Into: Selection .....and the resulting temporary table would be called "Query1". You could then update the 'Last_Column' located in Query1 with information contained from Table_2, which (because query1 is still linked to Table_1) would automatically update Table_1 for you, and it would not overwrite already populated fields in Table_1. The process could then be repeated for the remaining table. I hope that this helps? Kind Regards, Mark Kindler Training & Technical Support Spatial Technologies South Africa Tel: +2711 807 3807 (Ext 222) Fax: +2711 803 0010 Mobile: +2782 566 5127 email: [EMAIL PROTECTED] Web Site: www.spatial.co.za -----Original Message----- From: Robert Krotofil [mailto:[EMAIL PROTECTED] Sent: 07 September 2005 16:00 To: [email protected] Subject: MI-L how to update tables Hi All Could anyone explain me how to update tables in MapInfo (7.8)? I have three same tables (different names) but in the last column (Additional_info) each table has information for different records (and is empty for other records). I would like to have all additional_info information in one table, but when I'm using "update column" I'm overwriting information existing in one table, with information and unfortunately empty cells from the next table. Thanks Robert Krotofil This email, and any attachment, is confidential and intended only for the named addressees. Any unauthorised use of the message or attachments is strictly prohibited. If you receive it by mistake, please advise the sender by email immediately. Unless stated otherwise, any opinions are personal and cannot be attributed to Maidstone Borough Council. This email is not a contract or an order. It is your responsibility to carry out virus checks before opening any attachment. For information on Maidstone and Maidstone Borough Council visit www.digitalmaidstone.co.uk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17774 -------------------------------------------------------------------------------- Should you wish to receive regular updates on new products and services, please subscribe to our mailing list by sending your name, e-mail address and company name to [EMAIL PROTECTED] with 'Subscribe' in the subject line. Disclaimer and Confidentiality Notice: This message and the attached files contain information intended for the exclusive perusal and/or use (if so stated), of the addressee(s) only. The information may be confidential and legally privileged and protected by law. Access is authorised only by the intended recipient(s). If you are not an intended recipient, do not peruse, use, disseminate, distribute, copy or in any manner rely upon the information contained in this message or the attached files (directly or indirectly). The sender and/or Spatial Technologies (Pty) Ltd (ST) shall not be held liable for any loss damage, injury, or expense however caused, whether direct, indirect or consequential in the event that this prohibition is disregarded. If you receive this message and/or the attached files in error, please notify the sender immediately by e-mail, fax or telephone and return and/or destroy the original message. The views or representations contained in this message and/or the attached files, whether express or implied, are those of the sender only. ST and the sender do not warrant the truth, integrity, accuracy or completeness of the information provided, or that the message and attached files are free of errors, virus, interception or interference. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17776
