I am not sure on what column names you want to copy over so you will need to change them below.
Update Commoditytab set columnname = t2.columname from Commoditytab t1, johantab t2 where t1.tran_id = t2.tran_id Dan Goldberg From: 'Bo Franzén' via RBASE-L <[email protected]> Sent: Thursday, July 28, 2022 7:02 AM To: [email protected] Subject: [RBASE-L] - UPDATE column with the same column name FROM another table? Dear R:BASE, I have two tables of Medieval Swedish prices and one of them are for a translation into English since we have decided that the book we are planning should be published in English. While I was translating the eight thousand or so rows I used two variables in my form for (the English) Commoditytab going like this: vvara = vara in johantab WHERE tran_id = tran_id. And venhet = enhet in johantab WHERE tran_id = tran_id. It worked fine in both cases and the rows in the two tables are carrying the same number, i.e. tran_id. (And Sw. vara = Eng. commodity and Sw. enhet = Eng. numeral.) Johantab is the "original" database so to say. But now I have decided to skip Johantab in the editing and translation work and add the two important Swedish original columns FROM johantab into Commoditytab. (And yeas why didn’t I including them in the first place when creating Commoditytab from johantab?) I have added the two missing columns into Commoditytab - vara and enhet - and I have in vain tried to UPDATE SET = those two columns with the (TEXT) values FROM johantab. What syntax is needed by the R>prompt to copy the data from johantab to Commoditytab? Y s Bo Franzén Department of Economic History Stockholm University -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/656e4ea574c448ada236aea5521114e2%40ekohist.su.se<https://groups.google.com/d/msgid/rbase-l/656e4ea574c448ada236aea5521114e2%40ekohist.su.se?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F094B43%40EXCHANGE10.
