This is giving me headache, I changed SQL to: Select TableA.ColumnA, TableA.ColumnB, TableB.ColumnA, TableB.ColumnB from TableA, TableB where TableA.obj Intersects TableB.obj into New_Table
The New_Table has now 4 columns (all columns Char (2)) I want the two last columns (that is from TableB) to update the two first columns (that is from TableA) If I use the following selection Update Columns: Update New_Table Set TAA = TBA, TAB = TBB ###TAA is TableA Column A etc.### The result is giving me the values, but not in right order as they are from TableB, for example if I have value 11,11 in a row in TableB it gives me 13,13 in TableA!!!!! Instead of doing an update it messes up all my data in the selection for TableA. What I'm doing wrong? I have a "master" road network and got a part of it in another layer with updates that I need to transfer over to the "master". I thought by doing intersect you can then take the data from the update layer down to the "master" layer. Is this not the right way to do it? Any help is appreciated as I can't go any further just now. Thanks Regards S�ren -----Ursprungligt meddelande----- Fr�n: S�ren Lindqvist [mailto:[EMAIL PROTECTED] Skickat: den 13 september 2003 00:11 Till: [EMAIL PROTECTED] �mne: MI-L Uppdate value from tableB to tableA Dear list, I have two tables where one is updated (tableB). I need to update the data from tableB to tableA I have made two selections by SQL like this: Select * From TableA, TableB where TableA.obj Intersects TableB.obj into tmptA Select * From TableB, TableA where TableB.obj Intersects TableA.obj into tmptB Now I need to update columns "B" and "C" in tmptA with values from columns "B" and "C" in tmptB. How is it written? Update tmptA column B and C with values from tmptB columns B and C Regards S�ren --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8373 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8374
