摘要：
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. 阅读全文
