• 视图中添加主键的方法


    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;

  • 相关阅读:
    Java实现 LeetCode 697 数组的度(类似于数组的map)
    Java实现 LeetCode 697 数组的度(类似于数组的map)
    Java实现 LeetCode 697 数组的度(类似于数组的map)
    Java实现 LeetCode 696 计数二进制子串(暴力)
    Java实现 LeetCode 696 计数二进制子串(暴力)
    Java实现 LeetCode 696 计数二进制子串(暴力)
    Java实现 LeetCode 695 岛屿的最大面积(DFS)
    Java实现 LeetCode 695 岛屿的最大面积(DFS)
    PHP serialize() 函数
    PHP print_r() 函数
  • 原文地址:https://www.cnblogs.com/lihfeiblogs/p/5620036.html
Copyright © 2020-2023  润新知