你所指代的 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

所有跟帖： 

• o, lsf沒有問題，是main query的兩個table alias. 問題出在 -布衣之才- ♂ (428 bytes) () 08/08/2012 postreply 20:09:14