UPDATE `trans_detail-2013-12_` a,
(
SELECT MIN(EFFECTIVE_TIME) minTime,TRANS_CODE transCode FROM `trans_detail-2013-12_`
WHERE TRANS_CODE in(
'QTCK_1312_1_QTRK_1312_1',
'QTCK_1312_2_QTRK_1312_2',
'QTCK_1312_3_QTRK_1312_3',
'QTCK_1312_4_QTRK_1312_4',
'QTCK_1312_53_QTRK_1312_53',
'QTCK_1312_54_QTRK_1312_54'
) AND DETAIL_IN_OUT = 2 GROUP BY TRANS_CODE
) b
SET EFFECTIVE_TIME = b.minTime
WHERE
a.TRANS_CODE = b.transCode
;