select distinct praid,xh,xhmc,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,zxrmc,bjjsbz,
(case when wjbz ='0' then '未注销' when wjbz ='1' then '已注销' end) wjbz,
xhorder,ywmc,inviteschemeid,jbflag,zbbm from v_cgjhmx_zxqk_ztb
where zbbm ='2016120008'
order by jbflag,xhorder asc,zxbm,zxr 报错提示无效数字 已确认是视图问题CREATE OR REPLACE VIEW V_CGJHMX_ZXQK_ZTB AS
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'zbbh' ywmc,'60' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_20--招标编号
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'invitescheme' ywmc,'70' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_21--招标方案
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'invite' ywmc,'110' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_22--招标公告--【招标通知】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'bidapply' ywmc,'120' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_23--投标报名
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'inviteexes' ywmc,'130' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_24--标书费
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'inviteclarify' ywmc,'25' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_25--投标质疑
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'clarifypublicity' ywmc,'80' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_26--招标澄清--【澄清修改】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'deposit' ywmc,'140' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_27--保证金
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm, bjjsbz,'bid' ywmc,'150' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_28--投标书
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'bidopen' ywmc,'160' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_29--开标登记
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'techaudit' ywmc,'30' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_30--技术评标
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'jszjdf' ywmc,'180' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_31--技术专家打分--【专家评分】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'busiaudit' ywmc,'200' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_32--商务评标--【评标报告】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'swzjdf' ywmc,'190' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_33--商务专家打分--【评委评分】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'integrateaudit' ywmc,'210' xhorder,1 jbflag, sprq,baoid FROM
v_cgjhmx_zxqk_ztb_34--定标报告
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'prepublicity' ywmc,'35' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_35--预中标公示
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'publicity' ywmc,'220' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_36--中标公告--【评标结果公示】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'zbtzs' ywmc,'230' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_37--中标通知书--【评标通知书】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,0 inviteschemeid,zbbm,'1' bjjsbz,'cght' ywmc,'250' xhorder,1 jbflag, sprq,baoid FROM
v_cgjhmx_zxqk_ztb_38--采购合同
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,0 inviteschemeid,zbbm,'1' bjjsbz,'cgjs' ywmc,'39' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_39--付款申请单
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,'1' bjjsbz,'zbwj' ywmc,'41' xhorder FROM
--v_cgjhmx_zxqk_ztb_41--招标文件
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zdspb' ywmc,'42' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_42--文件送审
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zpbap' ywmc,'43' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_43--招评标安排
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'expertchoice' ywmc,'170' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_44--专家抽取--【评标委员】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgyswj' ywmc,'90' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_45--资格预审文件
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgyswjtj' ywmc,'46' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_46--资格预审文件提交
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgysbg' ywmc,'100' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_47--资格预审报告
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'depositth' ywmc,'240' xhorder,1 jbflag ,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_48--保证金退还
/**
* modified by Jiashaokai at 2011/04/08
* 加入bjjsbz ,在业务跟踪处,如果不等于1,则不能查看详细内容,默认为1
* ywmc 模块的业务名称, xh 标识页面弹出模块的方法
* xhmc 页面显示的名称不受此控制
* xhorder 模块的排序 页面展示的顺序在页面中控制 不受此参数控制
*/;
这个视图中所有的SELECT语句单独执行都正确,执行视图创建语句也没报错,我懵逼了,请求大神支援!!!!!
(case when wjbz ='0' then '未注销' when wjbz ='1' then '已注销' end) wjbz,
xhorder,ywmc,inviteschemeid,jbflag,zbbm from v_cgjhmx_zxqk_ztb
where zbbm ='2016120008'
order by jbflag,xhorder asc,zxbm,zxr 报错提示无效数字 已确认是视图问题CREATE OR REPLACE VIEW V_CGJHMX_ZXQK_ZTB AS
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'zbbh' ywmc,'60' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_20--招标编号
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'invitescheme' ywmc,'70' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_21--招标方案
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'invite' ywmc,'110' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_22--招标公告--【招标通知】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'bidapply' ywmc,'120' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_23--投标报名
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'inviteexes' ywmc,'130' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_24--标书费
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'inviteclarify' ywmc,'25' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_25--投标质疑
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'clarifypublicity' ywmc,'80' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_26--招标澄清--【澄清修改】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'deposit' ywmc,'140' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_27--保证金
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm, bjjsbz,'bid' ywmc,'150' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_28--投标书
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'bidopen' ywmc,'160' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_29--开标登记
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'techaudit' ywmc,'30' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_30--技术评标
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'jszjdf' ywmc,'180' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_31--技术专家打分--【专家评分】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'busiaudit' ywmc,'200' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_32--商务评标--【评标报告】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'swzjdf' ywmc,'190' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_33--商务专家打分--【评委评分】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'integrateaudit' ywmc,'210' xhorder,1 jbflag, sprq,baoid FROM
v_cgjhmx_zxqk_ztb_34--定标报告
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'prepublicity' ywmc,'35' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_35--预中标公示
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'publicity' ywmc,'220' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_36--中标公告--【评标结果公示】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'zbtzs' ywmc,'230' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_37--中标通知书--【评标通知书】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,0 inviteschemeid,zbbm,'1' bjjsbz,'cght' ywmc,'250' xhorder,1 jbflag, sprq,baoid FROM
v_cgjhmx_zxqk_ztb_38--采购合同
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,0 inviteschemeid,zbbm,'1' bjjsbz,'cgjs' ywmc,'39' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_39--付款申请单
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,'1' bjjsbz,'zbwj' ywmc,'41' xhorder FROM
--v_cgjhmx_zxqk_ztb_41--招标文件
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zdspb' ywmc,'42' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_42--文件送审
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zpbap' ywmc,'43' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_43--招评标安排
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'expertchoice' ywmc,'170' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_44--专家抽取--【评标委员】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgyswj' ywmc,'90' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_45--资格预审文件
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgyswjtj' ywmc,'46' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_46--资格预审文件提交
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgysbg' ywmc,'100' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_47--资格预审报告
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'depositth' ywmc,'240' xhorder,1 jbflag ,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_48--保证金退还
/**
* modified by Jiashaokai at 2011/04/08
* 加入bjjsbz ,在业务跟踪处,如果不等于1,则不能查看详细内容,默认为1
* ywmc 模块的业务名称, xh 标识页面弹出模块的方法
* xhmc 页面显示的名称不受此控制
* xhorder 模块的排序 页面展示的顺序在页面中控制 不受此参数控制
*/;
这个视图中所有的SELECT语句单独执行都正确,执行视图创建语句也没报错,我懵逼了,请求大神支援!!!!!
我怀疑问题存在这里。