CREATE OR REPLACE VIEW xv_cxtj_jmss_jd
AS
SELECT XT_SOM_JZRQ.f_cardid,
XF_CXTJ_BASE_YHQYMCID_CARDID(Xt_RMS_card.f_cardid) f_qymcid,
XT_SOM_JZRQ.f_qssj,
XT_SOM_JZRQ.f_jzsj,
XT_PMS_PD.F_PDBH,
XT_PMS_PD.F_PDMC,
XF_CXTJ_BASE_YHBH_CARDID(Xt_RMS_card.f_cardid) f_bh1,
XF_CXTJ_YHXM_CARDID(Xt_RMS_card.f_cardid) f_xm,
XF_CXTJ_BASE_YHDZ_CARDID(Xt_RMS_card.f_cardid) f_dz,
XF_CXTJ_BASE_YHDH_CARDID(Xt_RMS_card.f_cardid) f_dh1,
Xt_RMS_card.f_CardNo,
XT_PMS_PD.F_PDLX,
XT_PMS_PD.F_CASID,
XT_PMS_PD.F_SQFS,
XT_PMS_PD.F_PDID
FROM Xt_RMS_card
JOIN xt_sis_yh
ON Xt_RMS_card.f_yhid = xt_sis_yh.f_yhid
JOIN XT_SOM_JZRQ
ON Xt_RMS_card.f_cardid = XT_SOM_JZRQ.f_cardid
JOIN XT_PMS_PD
ON XT_SOM_JZRQ.f_pdid = XT_PMS_PD.F_PDID
WHERE ( XT_PMS_PD.F_PDBH <> '01' )这是一个视图,创建的时候报XF_CXTJ_BASE_YHDH_CARDID 00904 列无效的错误,但是这个视图里面所用的四个函数写法都一摸一样。为什么就只报最后一个视图错误呢?
AS
SELECT XT_SOM_JZRQ.f_cardid,
XF_CXTJ_BASE_YHQYMCID_CARDID(Xt_RMS_card.f_cardid) f_qymcid,
XT_SOM_JZRQ.f_qssj,
XT_SOM_JZRQ.f_jzsj,
XT_PMS_PD.F_PDBH,
XT_PMS_PD.F_PDMC,
XF_CXTJ_BASE_YHBH_CARDID(Xt_RMS_card.f_cardid) f_bh1,
XF_CXTJ_YHXM_CARDID(Xt_RMS_card.f_cardid) f_xm,
XF_CXTJ_BASE_YHDZ_CARDID(Xt_RMS_card.f_cardid) f_dz,
XF_CXTJ_BASE_YHDH_CARDID(Xt_RMS_card.f_cardid) f_dh1,
Xt_RMS_card.f_CardNo,
XT_PMS_PD.F_PDLX,
XT_PMS_PD.F_CASID,
XT_PMS_PD.F_SQFS,
XT_PMS_PD.F_PDID
FROM Xt_RMS_card
JOIN xt_sis_yh
ON Xt_RMS_card.f_yhid = xt_sis_yh.f_yhid
JOIN XT_SOM_JZRQ
ON Xt_RMS_card.f_cardid = XT_SOM_JZRQ.f_cardid
JOIN XT_PMS_PD
ON XT_SOM_JZRQ.f_pdid = XT_PMS_PD.F_PDID
WHERE ( XT_PMS_PD.F_PDBH <> '01' )这是一个视图,创建的时候报XF_CXTJ_BASE_YHDH_CARDID 00904 列无效的错误,但是这个视图里面所用的四个函数写法都一摸一样。为什么就只报最后一个视图错误呢?
脚本是工具自动生成的,它把函数放在了后面,所以导致创建这个视图的时候这个函数还不存在。谢谢兄弟们