提示标示符无效?!
SELECT "CASE_BASE"."CASE_ID",
"CASE_BASE"."OUT_DIAGNOSIS",
"CASE_BASE"."OUT_RESULT",
"CASE_BASE"."OUT_ICD",
"CASE_BASE"."HOSPITAL_INFECTION",
"CASE_BASE"."INFECTION_RESULT",
"CASE_BASE"."INFECTION_ICD",
"CASE_BASE"."PATHOLOGY_DIAGNOSIS",
"CASE_BASE"."PATHOLOGY_DIAGNOSIS_ICD",
"CASE_BASE"."EXTEND_REASON",
"CASE_BASE"."EXTEND_REASON_ICD",
"CASE_BASE"."MEDICINE_ANAPHYLACTIC",
"CASE_BASE"."HBSAG",
"CASE_BASE"."HCVAB",
"CASE_BASE"."HIVAB",
"CASE_BASE"."CLINIC_OUT",
"CASE_BASE"."IN_OUT",
"CASE_BASE"."OPERATION",
"CASE_BASE"."CLINIC_PATHOLOGY",
"CASE_BASE"."RADIO_PATHOLOGY",
"CASE_BASE"."SALVAGE_TIMES",
"CASE_BASE"."SUCCESS_TIMES",
"CASE_BASE"."DEPT_DIRECTOR",
"CASE_BASE"."DIRECTOR_DOCTOR",
"CASE_BASE"."MASTER_DOCTOR",
"CASE_BASE"."IN_DOCTOR",
"CASE_BASE"."STUDY_DOCTOR",
"CASE_BASE"."PRACTICE_DOCTOR",
"CASE_BASE"."PRACTICE_DOCTOR2",
"CASE_BASE"."CODER",
"CASE_BASE"."CASE_QUALITY",
"CASE_BASE"."QUALITY_DOCTOR",
"CASE_BASE"."QUALITY_NURSE",
"CASE_BASE"."QUALITY_DATE",
1 OPERATION_FLAG,
1 COLUMN_END,
'' COLUMN_SUBDIAGNOSIS,
'' COLUMN_INFECTION,
"CASE_BASE"."XYDYFY_ICD_ATTACH",
'' XYDYFY_ICD_ATTACH_NAME,
"CASE_BASE"."DIAGNOSIS_REASON",
"CASE_BASE"."PATHOLOGY_NO",
"CASE_BASE"."SICK_DATE"
FROM "CASE_BASE"
WHERE CASE_ID = :as_id
高手帮忙看下这段语句 提示ORA-00904:"CASE_BASE"."SICK_DATE" 标示符无效
这事咋回事?请教下各位
[解决办法]
没有SICK_DATE这一列.
[解决办法]
SICK_DATE 列是否存在?