Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
2.7k 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 Reply

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...