update B set B.sdctacode_status = A.sdctacode_status from A, Bwhere A.init_date=20130423and A.sdcexch_type = B.sdcexch_typeand A.sdc_code = B.sdc_code