• 视图中添加主键的方法


    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 交地、动工、竣工 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 JOIN 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;

  • 相关阅读:
    课堂作业1
    懒人创造了方法
    四则运算
    动手动脑与原码反码补码
    java测试感受
    暑假进度报告四
    暑假进度报告三
    暑假进度报告二
    暑假进度报告一
    《大道至简》读后感
  • 原文地址:https://www.cnblogs.com/lihfeiblogs/p/5620036.html
Copyright © 2020-2023  润新知