o, lsf没有问题，是main query的两个table alias. 问题出在

来源: 布衣之才 于 2012-08-08 20:09:14 [] [博客] [旧帖] [给我悄悄话] 阅读数 : (428 bytes)
回答: 你所指代的 o and lsf 分别在这两个 由 JJGL 于 2012-08-08 16:50:20

documentation_level_desc in the first sub query has been aliased  as cmdm_doc_type, and  SPECIAL_FEATURE_CODE in the second sub query has been aliased as Harp_CODE. Therefore in the main where clause the original field names can not be used, instead their alias names should be used.

请您先登陆，再发跟帖！