这个update语句错在哪里？

[jianshao810]

UPDATE OutStat15Day_20120123
SET a.VlrNum =b.VlrNum
FROM OutStat15Day_20120123 a JOIN test b
ON a.HlrNum=b.HlrNum;

UPDATE OutStat15Day_20120123
SET a.VlrNum =b.VlrNum,a.NewStatTime=b.mTime
FROM OutStat15Day_20120123 a, test b
WHERE a.HlrNum=b.HlrNum

两个都不行。
报 无法执行语句。 in predicate
这个错。

[wwwwb]

UPDATE OutStat15Day_20120123
SET VlrNum =（SELECT VlrNum
FROM JOIN test b WHERE OutStat15Day_20120123.HlrNum=b.HlrNum）;

[jianshao810]

还是不行。。提示无法执行语句

[baiynije]

UPDATE OutStat15Day_20120123
SET VlrNum =b.VlrNum,
NewStatTime=b.mTime
FROM OutStat15Day_20120123 a, test b
WHERE a.HlrNum=b.HlrNum

[wwwwb]

UPDATE OutStat15Day_20120123
SET VlrNum =（SELECT VlrNum
FROM test b WHERE OutStat15Day_20120123.HlrNum=b.HlrNum）;

[ACMAIN_CHM]

你test表中对应的记录有几条？

[xptking]

UPDATE OutStat15Day_20120123 a
SET a.VlrNum =b.VlrNum
FROM test b
where a.HlrNum=b.HlrNum;

[iihero]

什么数据库？确定是Sybase ASE?

[13193887977]

sybase为什么要带个分号？

UPDATE OutStat15Day_20120123
SET VlrNum = b.VlrNum
FROM test b
where OutStat15Day_20120123.HlrNum = b.HlrNum