SELECT MBMEMBMASTER.COOP_ID, MBMEMBMASTER.MEMBER_NO , MBUCFMEMBGROUP.MEMBGROUP_CODE , MBUCFMEMBGROUP.MEMBGROUP_DESC , MBMEMBMASTER.MEMB_NAME , MBMEMBMASTER.MEMB_SURNAME , MBMEMBMASTER.BIRTH_DATE , MBMEMBMASTER.RETRY_DATE , MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.SALARY_ID FROM MBMEMBMASTER, MBUCFMEMBGROUP, MBUCFPRENAME WHERE MBMEMBMASTER.MEMBGROUP_CODE = MBUCFMEMBGROUP.MEMBGROUP_CODE and MBMEMBMASTER.COOP_ID = MBUCFMEMBGROUP.COOP_ID and MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE DELETE FROM "MBGAINMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "MBGAINMASTER" ("COOP_ID", "MEMBER_NO", "SEQ_NO", "GAIN_NAME", "GAIN_SURNAME", "GAIN_ADDR", "GAIN_RELATION", "REMARK", "WRITE_DATE", "WRITE_AT", "AGE", "CONDITION_TYPE", "CONDITION_ETC") VALUES (:COOP_ID, :MEMBER_NO, :SEQ_NO, :GAIN_NAME, :GAIN_SURNAME, :GAIN_ADDR, :GAIN_RELATION, :REMARK, :WRITE_DATE, :WRITE_AT, :AGE, :CONDITION_TYPE, :CONDITION_ETC) SELECT * FROM MBGAINMASTER UPDATE "MBGAINMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "SEQ_NO" = :SEQ_NO, "GAIN_NAME" = :GAIN_NAME, "GAIN_SURNAME" = :GAIN_SURNAME, "GAIN_ADDR" = :GAIN_ADDR, "GAIN_RELATION" = :GAIN_RELATION, "REMARK" = :REMARK, "WRITE_DATE" = :WRITE_DATE, "WRITE_AT" = :WRITE_AT, "AGE" = :AGE, "CONDITION_TYPE" = :CONDITION_TYPE, "CONDITION_ETC" = :CONDITION_ETC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SEQ_NO" = :Original_SEQ_NO))