[SQL ] set + group by + inner join一起用

[dividi (阿福加油~!!)]

我使用的是MS SQL
有個表格二如下:
id  PP1Runs
AA  10
BB  20
CC  30
AA  40

我想把表格二各ID的總合更新到表格一去
但是使用下面的code一直有錯誤
update Table1
set Bat_PP1runs = t2.SUM(PP1RUNS)
from Table t1 inner join Table2  t2
on t1.ID = t2.ID
group by ID

Incorrect syntax near the keyword 'group'.

奇怪的是如果我單純用select而不是set卻沒問題
變成我現在是把他先select into第三個表格再更新回第二個表格

select ID as ID, sum(PP1Runs) as PP1Runs into #temp
from Table1 t1 inner join Table2 t2
on t1.ID = t2.ID
group by ID

update Table1
set Bat_PP1runs = t3.PP1Runs
from Table t1 inner join #temp t3
on t1.ID = t2.ID

怎麼看都是多此一舉...
好像只需要更動一點部分但我一直試不出來
請強者指點一下orz
非常感謝


--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 77.99.129.48