create view gv_per_acct
as
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" );