Oracle Query - help

Why the following code not work -invalid identifier  on documentation_level_desc .

 

SELECT  TO_NUMBER (l.loan_number) AS srvcnum,

         l.product_type_id AS cmdm_Market_Type_num,

        

         (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

           

    FROM CMDMmgr.loan l

         LEFT JOIN CMDMmgr.loan_origination o

            ON l.loan_number = o.loan_number

         LEFT JOIN CMDMmgr.LOAN_SPECIAL_FEATURE lsf

            ON l.loan_number = lsf.loan_number

   WHERE (product_type_id in (103, 104, 108, 116, 117, 119, 123,

                                                                                    731, 732, 733, 734, 735, 737, 738, 739)

                                                or documentation_level_desc in ('Signature NCO New Value' 'Signature NCO Orig Value')

                                                or SPECIAL_FEATURE_CODE in ('X908' 'T746' 'T786' 'T839' 'T840')

                )

所有跟帖： 

• Add a 逗號 in the in clause of last two lines. -美國老土- ♂ (0 bytes) () 08/08/2012 postreply 14:00:10

• 回複：still not working -Risk- ♂ (30174 bytes) () 08/08/2012 postreply 14:16:38

• put table name in front of -gchai- ♀ (772 bytes) () 08/08/2012 postreply 15:12:38

• 先看一下這個 -安心草- ♀ (2611 bytes) () 08/08/2012 postreply 15:24:24

• 你所指代的 o and lsf 分別在這兩個 -JJGL- ♀ (6629 bytes) () 08/08/2012 postreply 16:50:20

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

• 回複：Oracle Query - help -nopanic- ♀ (1104 bytes) () 08/08/2012 postreply 18:49:54

• 回複：Oracle Query - help -花心野趣- ♂ (20609 bytes) () 08/08/2012 postreply 19:01:24

• 為啥不都用join呢？ -smile2- ♀ (2538 bytes) () 08/08/2012 postreply 19:36:05

• 回複：Oracle Query - help -布衣之才- ♂ (25703 bytes) () 08/08/2012 postreply 20:12:35

• the issues of the query -ffppyy- ♂ (1467 bytes) () 08/08/2012 postreply 22:15:23

• 2nd line from last, need d.documentation_level_desc since your ' -kamioka- ♀ (0 bytes) () 08/09/2012 postreply 16:18:34

• since your 'from' is file l but documentation_level_desc is from -Kamioka- ♀ (0 bytes) () 08/09/2012 postreply 16:21:02

• documentation_level_desc is from d. also need sf. in front of th -Kamioka- ♀ (0 bytes) () 08/09/2012 postreply 16:22:52

• also need sf. in front of the variable in last line. -Kamioka- ♀ (0 bytes) () 08/09/2012 postreply 16:24:09