UC知道ASP带子查询的update
来源：百度知道 编辑：UC知道 时间：2024/05/11 01:38:32
UPDATE SC
SET Grade=0
WHERE 'CS'=
(SELETE Sdept
FROM Student
WHERE Student.Sno = SC.Sno)
写在asp中好像执行不了，数据库是access的，怎样才能在asp中实现这种多表更新
SET Grade=0
WHERE 'CS'=
(SELETE Sdept
FROM Student
WHERE Student.Sno = SC.Sno)
写在asp中好像执行不了，数据库是access的，怎样才能在asp中实现这种多表更新
update sc set grade=0 from sc join student on Student.Sno = SC.Sno and student.Sdept=sc.cs
UPDATE SC
SET Grade=0
WHERE 'CS'=
(SELETE Sdept
FROM Student
WHERE Student.Sno = SC.Sno)
写在asp中好像执行不了，数据库是access的，怎样才能在asp中实现这种多表更新.