标题: 帮忙看看这个UPDATE语句问题么？ [打印本页] 作者: winfly 时间: 2008-05-13 18:47 标题: 帮忙看看这个UPDATE语句问题么？ Update YB_SCMX a Set a.dj = (Select b.dj From YW_ZYFYMX b Where a.zyh = b.zyh and a.xmbm = b.xmbm and a.dh = b.dh and to_date(a.rq) = b.rq);
为什么总是提示SQL error -201 : A Syntax error has occurred
请帮忙，谢谢作者: ivhb 时间: 2008-05-14 08:54
Update YB_SCMX Set dj = (
Select b.dj
From YW_ZYFYMX b
Where YB_SCMX.zyh = b.zyh
and YB_SCMX.xmbm = b.xmbm
and YB_SCMX.dh = b.dh
and to_date(YB_SCMX.rq) = b.rq
);