create temp table tSeibun as select distinct ippanmei, seibun, seibun as shoryaku, ippanmei as kanryaku from seibun where ippanmei != seibun; update tSeibun set ...