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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/656e4ea574c448ada236aea5521114e2%40ekohist.su.se.
