Susan, another workaround would be to create an additional column in both tables where you combine "col1+col2" with "update column". Make sure the combined column is type character otherwise it might summarize your data.
Christine -----Urspr�ngliche Nachricht----- Von: Susan Yu [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. September 2004 20:05 An: [EMAIL PROTECTED] Betreff: MI-L Update Column by matching 2 fields Hi everyone, There is probably a very simple solution to my question, but I don't know it! I'm trying to update a column in a table by matching 2 fields with another table with the same 2 fields.... how do I do it? Table Update Column seem to only allow me one fields to match... so I tried using the Mapbasic window and wrote... Add Column "TableA" (ColumnWantsData )From TableB Set To ColumnWithData Where COL1=COL1 and COL2 = COL2 ... but didn't seem to like that "and" after COL1. Any help is appreciated. Thanks, Susan --------------------------------- Post your free ad now! Yahoo! Canada Personals --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13181
