SQLCODE=-206, SQLSTATE=42703

SELECT
    *
FROM
    (   SELECT
            REC_CREATOR                                        AS "recCreator",
            REC_CREATOR_NAME                                   AS "recCreatorName",
            REC_CREATE_TIME                                    AS "recCreateTime",
            REC_REVISOR                                        AS "recRevisor",
            REC_REVISOR_NAME                                   AS "recRevisorName",
            REC_REVISE_TIME                                    AS "recReviseTime",
            ARCHIVE_FLAG                                       AS "archiveFlag",
            ARCHIVE_TIME                                       AS "archiveTime",
            ARCHIVE_STAMP_NO                                   AS "archiveStampNo",
            SEQ_NUM                                            AS "seqNum",
            COMPANY_CODE                                       AS "companyCode",
            SALE_ORG                                           AS "saleOrg",
            CURRENCY                                           AS "currency",
            DELIVERY_DATE_6                                    AS "deliveryDate6",
            RATE                                               AS "rate",
            VERSION_NUM                                        AS "versionNum",
            DISC_DAYS                                          AS "discDays",
            DISC_BASE_DATE                                     AS "discBaseDate",
            DISC_MODE                                          AS "discMode",
            REMARK                                             AS "remark",
            REMARK1                                            AS "remark1",
            REMARK2                                            AS "remark2",
            REMARK3                                            AS "remark3",
            NOTE_TYPE                                          AS "noteType",
            PAPER_TYPE                                         AS "paperType",
            RATE_START_DATE                                    AS "rateStartDate" ,
            DECODE(RATE_END_DATE,' ','99991231',RATE_END_DATE) AS "rateEndDate"
        FROM
            ISMS.TSAHYSA16 
        WHERE 
            NOTE_TYPE = 'B61'
        AND PAPER_TYPE ='1' ) A16
        WHERE 1=1
        AND A16.RATE_START_DATE<= '20220201'
        AND A16.rateEndDate >='99991231'

这个报sqlcode=‘-206’，我看了字段啥的都没问题啊
求

删除select前面的(`)符号再试试：

你把你sql里面, as 后面的列名的双引号全部去掉，然后把那个 RATE_START_DATE 改成 RATESTARTDATE 。
这个报错是因为"列名没有在FROM语句所引用的任何表中“
即 RATE_START_DATE 和 ”rateStartDate“ 不一致， rateEndDate 和"rateEndDate" 也不一致

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632