DELETE,UPDATE与LEFT JOIN
摘要:
UPDATE:UPDATE A SET ApproverID=NULL,ApproveDate=NULL,ApproveResult=100,CheckerID=null,CheckDate=null, IsCheck=0 FROM [SH_MaterialApplyBuyBill] A LEFT JOIN [SH_MaterialApplyBuyBillDetail] B ON A.ID=B.[... 阅读全文
posted @ 2007-11-27 13:39 优雅小猪 阅读(5946) 评论(1) 推荐(1) 编辑