update t_im_branch_stock set stock_qty='0' where item_no in (select item_no from t_pc_branch_price where sale_way='C')