select * from ws_worksheet_instance_t a, bi_vop_push_result_file_t b
where a.PRESERVE01 = b.ORDER_ID and a.PICK_STATUS = 1
我想修改ws_worksheet_instance_t 表中的PICK_STATUS=2，上句为修改条件，为什么我
update ws_worksheet_instance_t set PICK_STATUS=2 where (select * from ws_worksheet_instance_t a, bi_vop_push_result_file_t b不行？
where a.PRESERVE01 = b.ORDER_ID and a.PICK_STATUS = 1)
该怎么做？
多谢了
------解决思路----------------------
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