建立个人信息视图
SELECT "G_CO_ACCT"."DWMC", "G_CO_ACCT"."DWDM",
"G_CO_ACCT"."DWDZ", "G_CO_ACCT"."YZBM", "G_CO_ACCT"."SZQX", "G_CO_ACCT"."ZGBM", "G_CO_ACCT"."LSGX", "G_CO_ACCT"."DWXZ", "G_CO_ACCT"."KHYH", "G_CO_ACCT"."YHZH", "G_CO_ACCT"."XXR", "G_CO_ACCT"."FXR", "G_CO_ACCT"."JBBM", "G_CO_ACCT"."LXR", "G_CO_ACCT"."LTEL", "G_CO_ACCT"."FZR", "G_CO_ACCT"."FTEL", "G_CO_ACCT"."YHLB", "G_PER_ACCT"."GRZH",
"G_PER_ACCT"."XM", "G_PER_ACCT"."XB", "G_PER_ACCT"."CSNY",
"G_PER_ACCT"."SFZH", "G_PER_ACCT"."SNYE", "G_PER_ACCT"."BHJE", "G_PER_ACCT"."BBJE", "G_PER_ACCT"."BBJCS", "G_PER_ACCT"."BZQE", "G_PER_ACCT"."BZQCS", "G_PER_ACCT"."DQYE", "G_PER_ACCT"."XY",
"G_PER_ACCT"."SNYJE", "G_PER_ACCT"."BNYJE", "G_PER_ACCT"."XNYJE", "G_PER_ACCT"."SNPJGZ", "G_PER_ACCT"."JJBL", "G_PER_ACCT"."ZGZT", "G_PER_ACCT"."KHRQ", "G_PER_ACCT"."DZRQ", "G_PER_ACCT"."XHRQ", "G_PER_ACCT"."HJBZ", "G_PER_ACCT"."SNHJBZ","G_PER_ACCT"."JJRQ", "G_PER_ACCT"."SNYEBD"
FROM "G_CO_ACCT", "G_PER_ACCT"
WHERE ( "G_CO_ACCT"."DWDM" = "G_PER_ACCT"."DWDM" )