Hello listers.... I'm sure we've had something like this before...? I want to update a column with the value from another table, but my join uses two keys.... this statement works: Add Column "NEWmaptargetnotes" (TargetNote) From TargetNotes Set To TargetNoteText Where COL1 = COL1 but when I try and add: AND COL3 = COL2 to the end of the statement MI doesn't recognise the command AND
What's wrong with this? All fields involved are indexed , but looks as if i'm going about this the wrong way, any ideas? Thanks Sion Roberts [EMAIL PROTECTED] _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
