在查询中同级查询中无法识别别名:
SELECT C.FW_ZL, C.AA, a.FW_ADDRESS, C.FH, C.FH_NM, C.FW_NM
FROM (select b.FW_ZL,
(substr(b.fw_zl, 0, instr(b.fw_zl, '市场', 1, 1) - 1) || '城' ||
substr(b.fw_zl, instr(b.fw_zl, '市场', 1, 1) + 2, 1) || '幢' ||
(case substr(b.fw_zl, instr(b.fw_zl, '市场', 1, 1) + 2, 1)
when 'D' then
substr(b.fw_zl,
instr(b.fw_zl, 'D幢', 1, 1) + 2,
instr(b.fw_zl, '室', -1, 1) -
instr(b.fw_zl, 'D幢', 1, 1) - 2)
else
substr(b.fw_zl,
instr(b.fw_zl, '市场', 1, 1) + 2,
instr(b.fw_zl, '室', -1, 1) -
instr(b.fw_zl, '市场', 1, 1) - 2)
end) || '号') AA,
b.FH,
b.FH_NM,
b.FW_NM
from sccadmin.T_ZSKFH b
where b.PRESELL_ID = 2251) C,
jycq.T_HOUSE a
WHERE C.AA = a.FW_ADDRESS
AND a.fw_dh like '4188-1810-0008%'
SELECT C.FW_ZL, C.AA, a.FW_ADDRESS, C.FH, C.FH_NM, C.FW_NM
FROM (select b.FW_ZL,
(substr(b.fw_zl, 0, instr(b.fw_zl, '市场', 1, 1) - 1) || '城' ||
substr(b.fw_zl, instr(b.fw_zl, '市场', 1, 1) + 2, 1) || '幢' ||
(case substr(b.fw_zl, instr(b.fw_zl, '市场', 1, 1) + 2, 1)
when 'D' then
substr(b.fw_zl,
instr(b.fw_zl, 'D幢', 1, 1) + 2,
instr(b.fw_zl, '室', -1, 1) -
instr(b.fw_zl, 'D幢', 1, 1) - 2)
else
substr(b.fw_zl,
instr(b.fw_zl, '市场', 1, 1) + 2,
instr(b.fw_zl, '室', -1, 1) -
instr(b.fw_zl, '市场', 1, 1) - 2)
end) || '号') AA,
b.FH,
b.FH_NM,
b.FW_NM
from sccadmin.T_ZSKFH b
where b.PRESELL_ID = 2251) C,
jycq.T_HOUSE a
WHERE C.AA = a.FW_ADDRESS
AND a.fw_dh like '4188-1810-0008%'
解决方案 »
- 关于导入数据库的问题
- 求一句分层汇总SQL
- Oralce 密集数据插入问题!
- linux下如何使用oracle9i?
- 关于UDUMP目录下的跟踪文件的问题?在线等。。。
- 8i使用中.... system用户没有创建数据库的权限吗?
- ROW-00060:内部错误:[daputchunk,2]
- 为什么我的 database configuration assistant 不能用??
- 求一个触发器,在插入的时候,取一个序数放入表中,如何写?
- varchar在建表时的疑惑?哪位能解释一下
- 更改archivelog日志备份路径后,备份路径没有产生日志文件
- Neo4j的BatchInserterIndex问题
where子句的执行顺序
1、from
2、where
3、group
4、having
5、select
6、order
某些子句没有则跳过
where子句的执行早于select子句,因此select子句中的别名在执行where时还未生效,不能使用