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)) 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, mbmembmaster.gaincond_type, mbmembmaster.gaincond_desc, mbmembmaster.gaincond_date 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