Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
450 views
in Technique[技术] by (71.8m points)

请教怎么把表2某列的值加到表1相应列上

比如我在DolphinDB中有下面2张表:

code=`A`B`C`D`E
totalValue=10 20 30 40 50
t1=keyedTable(`code,code,totalValue)

t2 = table(`A`C`B`D as code,  1..4 as value)

我想把t2中value加到t1中相同code的totalValue上,使得 totalValue = totalValue + t2.value,这个应该怎么处理?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

可用ej实现,例如:

update t1 set totalValue=totalValue+t2.value  from ej(t1,t2,`code)

或者

update t1 set totalValue=totalValue+t2.value where t1.code=t2.code

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...