17,075
社区成员
发帖
与我相关
我的任务
分享
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%'