你所指代的 o and lsf 分別在這兩個

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