2013年11月24日
级连查询与更新
摘要： select DATEADD(day,v.LearningDay,sc.OrderTime) AS OrderPayDate, sc.LearninTime,v.VideoTitle,sc.OrderTime,v.LearningDay from ShoppingCart scleft join video v on sc.MatterId=v.Idwhere sc.OrderTime is not nullupdate scset sc.LearninTime = r.OrderPayDatefrom ShoppingCart sc,(select sc.Id, DATEADD(day,v. 阅读全文
posted @ 2013-11-24 11:59 黑 瞳 阅读(435) 评论(0) 推荐(0)