Hi "Pclifton", If what you want to do with a single table is described in these two steps :
1. Select * From table2Bupdated, tableWithValues Where table2Bupdated.joinColumn = tableWithValues.joinColumn 2. Update Selection set column2update = columnWithValue then I'll suggest that you add these two lines 50 times to a new text file, change the tabel/column names appropriately throughout the file (e.g. 50 different tables to update with), and insert these three lines at the very top of the file : !Workspace !Version 500 !Charset WindowsLatin1 and save the file as *.WOR. Then you can execute the 100 commands in one go by "opening" the created "workspace" file. Using a join ensures that you only update the rows that correspond to value in the updater table. Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ ----- Original Message ----- From: "Pclifton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 14, 2004 8:03 AM Subject: MI-L Column Update--a simple solution? > I have a table with about 10,000 unique names in Column 1, and I wish to > update data in Column 2 from about 50 other tables. The common link is the > names in Column 1. Using Update Column, the second update erases the data > from the first update, and so on. It is not feasible to concatanate the > tables, and I don't want to go through a multistep process in SQL for each > table. dBase handles this type of job with ease--what is the easy solution > in MapInfo? > > > _____________________________________________________________ > Great Basin Internet Services Webmail (http://greatbasin.net) > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 12178 > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12179
