UPDATE biometric_image dt1, biometric_image dt2
SET dt1.cam_img = dt2.cam_img
WHERE (dt1.comcaseno='775/2012' AND dt1.partytype='seller' AND dt1.partyserial='1') AND (dt2.comcaseno='775/2012' AND dt2.partytype='drafter' AND dt2.partyserial='1')
SET dt1.cam_img = dt2.cam_img
WHERE (dt1.comcaseno='775/2012' AND dt1.partytype='seller' AND dt1.partyserial='1') AND (dt2.comcaseno='775/2012' AND dt2.partytype='drafter' AND dt2.partyserial='1')
No comments:
Post a Comment