update cp_stock_check_detail set beginnum =
(select endnum from cp_stock_check_detail a
where org='1795' and op_data='20050425' and a.org=org and a.goods=a.goods and
a.warehouse=warehouse)
where op_date='2005-04-26';
(select endnum from cp_stock_check_detail a
where org='1795' and op_data='20050425' and a.org=org and a.goods=a.goods and
a.warehouse=warehouse)
where op_date='2005-04-26';
a.org='1795' and a.op_date='2005-04-26' and
a.org=b.org and a.goods=b.goods and a.warehouse=b.warehouse)
where exists (select 1 from cp_stock_check_detail where org='1795' and op_date='2005-04-25')