假设我有下面两个表格
sheet1
sheet2
我想通过UPDATE语句,将sheet1 ID1 =5对应的num1值修改为 sheet2中所有num2的和,那么这个sql语句该怎么写呢?
我写了这样一句
string strSql = @"update [Sheet1$]
SET num1 = t1.sum1
from (select sum([Sheet2$].num2 ) as sum1 from [Sheet2$]) as t1
WHERE [Sheet1$].ID1=6";
但一直报错,说:“语法错误 (操作符丢失) 在查询表达式 't1.sum1 from (select sum([Sheet2$].num2) as sum1 from [Sheet2$]) as t1 ' 中。”
改了好几种形式都是这个错,求大佬指点一下。小萌新,没有悬赏还请大佬见谅。