Susan,
This is a pain that MapInfo won't support multi column update queries, but there is a workaround.
If you make a selection first:
Select * From TableA, TableB Where COl1=Col1 AND Col2=COl2 Into UpdateSet
Then use the table Update column command to update the query UpdateSet with data from the
ColumnWithData To ColumnWantsData.
You should get the desired result.
I have not spelled the process out in detail as you seem to know what you are doing, but if you need more detailed steps, please ask.
r
On Wed, 1 Sep 2004 14:04:32 -0400 (EDT), Susan Yu <[EMAIL PROTECTED]> wrote:
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
--
Robert Crossley Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13178
