超简单的问题我问一下。
update table1 set col = (select ....返回多个值)
提示单行字返回多行
我怎么改啊?UPDATE table3 SET sdryzs = (SELECT COUNT(t2.mc) FROM table1 t1,table2 t2
WHERE t1.sjjzd = t2.dm AND t2.MC IN (SELECT mc FROM table3)
GROUP BY t2.MC)
where table3.mc=t2.mc我想改成只要符合table3.mc=t2.mc 的sdryzs
update table1 set col = (select ....返回多个值)
提示单行字返回多行
我怎么改啊?UPDATE table3 SET sdryzs = (SELECT COUNT(t2.mc) FROM table1 t1,table2 t2
WHERE t1.sjjzd = t2.dm AND t2.MC IN (SELECT mc FROM table3)
GROUP BY t2.MC)
where table3.mc=t2.mc我想改成只要符合table3.mc=t2.mc 的sdryzs
解决方案 »
- linux下安装的oracle,为什么有时能启动,有时不能启动?
- 如何在Clob对象中查询??
- oracle编程指南?
- Can't connect to X11 window server using '127.0.0.1:0.0' as the value of the DISPLAY variable.
- oracle的exp操作与归档日志问题
- 急问:这样的Sql怎么写?
- 启动的问题
- sql*Plus 为何不能查询自创的表,在线等
- (在线等待,快速结贴)关于VB用OO4O访问Oracle中的blob字段(如图像),并显示在Image控件中.
- oracle数据库大数据量优化的问题?
- 在集群环境下如何安装ORACLE?
- oracle 安装到 net8 configuration assistant 死掉
如果这样还提示返回多行,只能说数据有问题了。
UPDATE table3
SET sdryzs = (select v.ct
from (SELECT COUNT(t2.mc) ct, t2.mc
FROM table1 t1, table2 t2
WHERE t1.sjjzd = t2.dm
AND t2.MC IN (SELECT mc FROM table3)
GROUP BY t2.MC) v
where table3.mc = v.mc)