update ws_worksheet_instance_t a
set PICK_STATUS=2
where exists (select 1 from bi_vop_push_result_file_t b
where a.PRESERVE01 = b.ORDER_ID)
and a.PICK_STATUS = 1
set PICK_STATUS=2
where exists (select 1 from bi_vop_push_result_file_t b
where a.PRESERVE01 = b.ORDER_ID)
and a.PICK_STATUS = 1
1楼是正解