你所指代的 o and lsf 分别在这两个

来源: 于 2012-08-08 16:50:20 [旧帖] [给我悄悄话] 本文已被阅读：次

statements里能work吗？他们在括号里指代什么呢？我想因此不能work吧。（我也是瞎猜的。）

(SELECT documentation_level_desc

FROM CMDMmgr.documentation_level_type d

WHERE o.documentation_level_id = d.documentation_level_id)

AS cmdm_doc_type,

(SELECT SPECIAL_FEATURE_CODE

FROM CMDMmgr.SPECIAL_FEATURE sf

WHERE TO_NUMBER (lsf.SPECIAL_FEATURE_ID) = sf.SPECIAL_FEATURE_ID)

AS Harp_CODE