Update tab1 t
Set (val1, val2) = (select val1, val2
from tab2
where workdate = t.workdate
and cino = t.cino);
服务器: 消息 170，级别 15，状态 1，行 1
第 1 行: 't' 附近有语法错误。
我的是MSSQL 2000，应该怎样写
------解决方案--------------------
那你就把这段都塞到t2里面
Update t1
Set t1.val1=t2.val1, t1.val2=t2.val2
from tab1 t1 , (select xxxxxxxxxxx) t2
where t2.workdate = t1.workdate and t2.cino = t1.cino
慢的话再调索引