insert into sto_stocks2(ym,prdt,whouse,kind,qty,indate,inuser,cdate,cuser)
select '200706' as ym,prdt,whouse,'101' as kind,qty1 as qty,indate,inuser,cdate,cuser from sto_checks where date_format(pdate,'%Y%m')='200706';
posted on 2007-08-10 14:14
小哈 阅读(191)
评论(0) 编辑 收藏 所属分类:
MySql+Access+MsSql