34,590
社区成员
发帖
与我相关
我的任务
分享这个update 怎么写
update set a set a.phbz='C'||to_char(b.jhrq,'yyyy-mm-dd hh:mm:ss') from b where (rtrim(ltrim(a.phbz)) is null or rtrim(ltrim(a.phbz))='') and a.phdh=b.bjlsh
更新a表的字段phbz=b.jhrq，条件a.phdh=b.bjlsh
更新a表的字段phbz=b.jhrq，条件a.phdh=b.bjlsh
...全文
请发表友善的回复…
发表回复
zhangzs8896 2004-08-13
- 打赏
- 举报
楼主多了个 set
rea1gz 2004-08-13
- 打赏
- 举报
update a set phbz='C'+convert(char(19),b.jhrq,120)
from b where (rtrim(ltrim(a.phbz)) is null or rtrim(ltrim(a.phbz))='')
and a.phdh=b.bjlsh
from b where (rtrim(ltrim(a.phbz)) is null or rtrim(ltrim(a.phbz))='')
and a.phdh=b.bjlsh
