子查询的款困惑
时间：2011-02-15
来源：互联网
本帖最后由 zhaoyh603 于 2011-02-15 21:47 编辑
select (select a.dept_fullname from ad_department a where a.dept_id = parent_id)||'_'||dept_name as b ,dept_name,parent_id from ad_department
Where Length(dept_Code) = 6 And dept_Code Like '99%' ;
b是空的
select b.dept_fullname||'_'||a.dept_name as b , a.dept_name from ad_department a,ad_department b where a.parent_id=b.dept_id;
可以
目的是想update dept_fullname
为什么呀 疑惑
select (select a.dept_fullname from ad_department a where a.dept_id = parent_id)||'_'||dept_name as b ,dept_name,parent_id from ad_department
Where Length(dept_Code) = 6 And dept_Code Like '99%' ;
b是空的
select b.dept_fullname||'_'||a.dept_name as b , a.dept_name from ad_department a,ad_department b where a.parent_id=b.dept_id;
可以
目的是想update dept_fullname
为什么呀 疑惑
作者: zhaoyh603 发布时间: 2011-02-15
本帖最后由 zhaoyh603 于 2011-02-15 21:47 编辑
select (select a.dept_fullname from ad_department a where a.dept_id = b.parent_id)||'_'||b.dept_name as b ,b.dept_name,b.parent_id from ad_department b
Where Length(b.dept_Code) = 6 And b.dept_Code Like '99%' ;
加了别名就可以了，晕 why
select (select a.dept_fullname from ad_department a where a.dept_id = b.parent_id)||'_'||b.dept_name as b ,b.dept_name,b.parent_id from ad_department b
Where Length(b.dept_Code) = 6 And b.dept_Code Like '99%' ;
加了别名就可以了，晕 why
作者: zhaoyh603 发布时间: 2011-02-15
本帖最后由 zhaoyh603 于 2011-02-15 21:48 编辑
update ad_department as b
set b.dept_fullname=(select a.dept_fullname from ad_department a where a.dept_id = b.parent_id)||'_'||b.dept_name
Where Length(b.dept_Code) = 6 And b.dept_Code Like '99%' ;
错误：
ERROR: column "b" of relation "ad_department" does not exist
LINE 2: set b.dept_fullname=(select a.dept_fullname from ad_departme...
update ad_department as b
set b.dept_fullname=(select a.dept_fullname from ad_department a where a.dept_id = b.parent_id)||'_'||b.dept_name
Where Length(b.dept_Code) = 6 And b.dept_Code Like '99%' ;
错误：
ERROR: column "b" of relation "ad_department" does not exist
LINE 2: set b.dept_fullname=(select a.dept_fullname from ad_departme...
作者: zhaoyh603 发布时间: 2011-02-15
晕呼，没看明白。
作者: renxiao2003 发布时间: 2011-02-15
本帖最后由 zhaoyh603 于 2011-02-15 21:48 编辑
update ad_department b
set dept_fullname=a.dept_fullname||'_'||b.dept_name
from ad_department as a
Where Length(b.dept_Code) = 6 And b.dept_Code Like '99%' and a.dept_id = b.parent_id;
这样可以
oracle这样貌似不行吧
什么标准？
update ad_department b
set dept_fullname=a.dept_fullname||'_'||b.dept_name
from ad_department as a
Where Length(b.dept_Code) = 6 And b.dept_Code Like '99%' and a.dept_id = b.parent_id;
这样可以
oracle这样貌似不行吧
什么标准？
作者: zhaoyh603 发布时间: 2011-02-15
看明白了吗？
作者: zhaoyh603 发布时间: 2011-02-15
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读：74
-
如何安装mysql8.0
阅读：31
-
Word快速设置标题样式步骤详解
阅读：28
-
20+道必知必会的Vue面试题（附答案解析）
阅读：37
-
HTML如何制作表单
阅读：22
-
百词斩可以改天数吗？当然可以，4个步骤轻松修改天数！
阅读：31
-
ET文件格式和XLS格式文件之间如何转化？
阅读：24
-
react和vue的区别及优缺点是什么
阅读：121
-
支付宝人脸识别如何关闭?
阅读：21
-
腾讯微云怎么修改照片或视频备份路径?
阅读：28
