CREATE OR REPLACE VIEW T_GDXM (
Gd_guid,
Zd_guid,
Xzq_dm
, Xm_guid
, Xm_zt
, Xm_xh
Bh
, DZ_BA_BH
, XM_MC
, TZZT_XZ
, HY_FL
, TD_JB
, ZD_BH
, Td_zl
, GD_ZMJ
, Gy_fs
, GY_MJ
, XZ_MJ
, Td_yt
, CR_NX
, YT_SM
, JD_SJ
, JE
, Gdzc_tze
, TZ_QD
, ZT_JZ_XZ
, FS_JZ_XZ
, JZ_MJ
, MIN_JZ_MD
, MAX_JZ_MD
, MIN_RJL
, MAX_RJL
, MIN_LHL
, MAX_LHL
, MIN_JZ_GD
, MAX_JZ_GD
, Qt_td_yq
, DG_SJ
, JG_SJ
, KFJS_QX
, QD_RQ
, PZ_WH
, PZ_RQ
, Pz_jg,kftz_ze
, CL_XZCR_MJ
, CL_GBXZCR_MJ
, CL_QT_MJ
, PC_MJ
, GY_WLD_MJ
, CL_XQ
, PZ_DW,CL_CR_MJ,
Jk_gc,pc_cr_mj,cl_mj
, SJ_JD_SJ
, SJ_DG_SJ
, SJ_JG_SJ
, Min_jz_md_tag
, Max_jz_md_tag
, Min_rjl_tag
, Max_rjl_tag
, Min_lhl_tag
, Max_lhl_tag
, Min_jz_gd_tag
, Max_jz_gd_tag
, HT_LX
, KFLY_BZ
, Wkfly_yy
, Sf_sh
, Xz_zt
, QY_SS_LX
, Lsxz_zt
, Have_jzd
Srr
, Cx_yy
, Is_stop
, ZJGG_MJ
, Gdxm_gzzt,
BG_DG_SJ,
Bg_jg_sj
, Bg_jd_sj,constraint "PK_T_GDXM" PRIMARY KEY (gd_guid) RELY DISABLE
) as
SELECT A.gd_guid,d.zd_guid zd_guid,xzq XZQ_DM
, B.xm_guid
, Xm_zt
---xm_xh
, 0 xm_xh
, Xmbh BH
--dz_ba_bh
, ' DZ_BA_BH
, JSXM_MC XM_MC
, TZZT_XZ
, HYFL HY_FL
, TDJB TD_JB
, ZDBH ZD_BH
, Tdzl Td_zl
, ZMJ GD_ZMJ
, Gdfs gy_fs
, HBMJ GY_MJ
, HB_XZCR_MJ XZ_MJ
, Sqyd_yt Td_yt
--CR_NX,YT_SM,
, 0 Cr_nx
, ' Yt_sm
, YDJD_SJ JD_SJ
, D.HBJK JE
, G.gy_tze Gdzc_tze
, Gy_tzqd TZ_QD
, F.zt_jsw_xz Zt_jz_xz
, Fs_jsw_xz Fs_jz_xz
, ZMJ JZ_MJ
, Jzmd_min MIN_JZ_MD
, Jzmd_max MAX_JZ_MD
, Rjl_min MIN_RJL
, Rjl_max MAX_RJL
, Ldl_min Min_lhl
, Ldl_max Max_lhl
, Jzxg_min MIN_JZ_GD
, Jzxg_max MAX_JZ_GD
, Qtyq Qt_td_yq
, YDDG_SJ DG_SJ
, YDJG_SJ JG_SJ
--, KFJS_QX
, 0 KFJS_QX
, Case gdfs when ' 1 ' then I.qfrq
ELSE J.QDRQ
END QD_RQ
, K.pzwh PZ_WH
, K.ZF_PZSJ PZ_RQ
, K.PZJG PZ_JG
,-fgy_tze Kftz_ze
, HB_XZCR_MJ CL_XZCR_MJ
, HB_GBXZ_MJ CL_GBXZCR_MJ
, QT_CLMJ CL_QT_MJ
--, PC_MJ
, 0 PC_MJ
, gy_wly GY_WLD_MJ
, Htxq CL_XQ
--, PZ_DW,CL_CR_MJ,
, ' pz_dw,0 CL_CR_MJ
--jk_gc,pc_cr_mj,cl_mj
, ' jk_gc,0 pc_cr_mj,0 CL_MJ
, SJ_JD_SJ
, SJ_KG_SJ SJ_DG_SJ
, SJ_JG_SJ
, Jzmd_min_tag Min_jz_md_tag
, Jzmd_max_tag Max_jz_md_tag
, Rjl_min_tag Min_rjl_tag
, Rjl_max_tag Max_rjl_tag
, Ldl_min_tag Min_lhl_tag
, Ldl_max_tag Max_lhl_tag
, Jzxg_min_tag Min_jz_gd_tag
, Jzxg_max_tag Max_jz_gd_tag
, 1 HT_LX
, 1 KFLY_BZ
, ' Wkfly_yy
, 0 sf_sh
, -1 Xz_zt
, ' QY_SS_LX
, -1 Lsxz_zt
, 1 Have_jzd
, B.sqyd_dw SRR
, ' Cx_yy
, ' Is_stop
, 0 ZJGG_MJ
, Xm_zt Gdxm_gzzt,
--yd, commencement, completion BG_JD_SJ,BG_DG_SJ,BG_JG_SJ
YDDG_SJ BG_DG_SJ,
YDJG_SJ BG_JG_SJ
, YDJD_SJ BG_JD_SJ
From T_GD_YWBH A INNER JOIN
T_gd_xmxx B on A.gd_guid=b.gd_guid
Left JOIN T_KC_KCDJ_CG C on B.xm_guid=c.xm_guid
Left JOIN t_kc_zdxx D on C.chcg_guid=d.chcg_guid
Left JOIN t_gd_xmxx_kz_gymj E on B.xm_guid=e.xm_guid
Left JOIN t_kf_kfly_yd F on B.xm_guid=f.xm_guid
Left joins T_kf_tzqd_yd G on G.kfly_guid=f.kfly_guid
Left JOIN t_kf_crtj_yd H on H.kfly_guid=f.kfly_guid
Left JOIN T_hbjds I on B.xm_guid=i.xm_guid
Left JOIN T_ht_crht J on B.xm_guid=j.xm_guid
Left JOIN t_sp_spxx K on B.xm_guid=k.xm_guid
WHERE b.mark=0;
Ways to add a primary key in a view