select mbmembmaster.member_no, '' as cp_name, mbucfmembtype.membtype_desc, mbucfmembgroup.membgroup_desc from mbmembmaster, mbucfprename, mbucfmembgroup, mbucfmembtype where mbmembmaster.prename_code = mbucfprename.prename_code and mbmembmaster.membgroup_code = mbucfmembgroup.membgroup_code and mbmembmaster.membtype_code = mbucfmembtype.membtype_code DELETE FROM "LNNPLFOLLOWMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("FOLLOW_SEQ" = :Original_FOLLOW_SEQ)) INSERT INTO "LNNPLFOLLOWMASTER" ("COOP_ID", "MEMBER_NO", "FOLLOW_SEQ", "MAVSET_BAL", "CONTLAW_STATUS") VALUES (:COOP_ID, :MEMBER_NO, :FOLLOW_SEQ, :MAVSET_BAL, :CONTLAW_STATUS) select coop_id, member_no, follow_seq, mavset_bal, contlaw_status from lnnplfollowmaster UPDATE "LNNPLFOLLOWMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "FOLLOW_SEQ" = :FOLLOW_SEQ, "MAVSET_BAL" = :MAVSET_BAL, "CONTLAW_STATUS" = :CONTLAW_STATUS WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("FOLLOW_SEQ" = :Original_FOLLOW_SEQ))