Ways to add a primary key in a view

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.