DELETE FROM SC WHERE 'CS'= (SELETE Sdept FROM Student WHERE Student.Sno=SC.Sno)

Question

服务器: 消息 170，级别 15，状态 1，行 4
第 4 行: 'Sdept' 附近有语法错误。

Answer 1

DELETE FROM SC WHERE 'CS'= (SELECT Sdept FROM Student WHERE Student.Sno=SC.Sno),关键字错误，你执行我的语句试试！本回答被提问者采纳

Answer 2

delete from sc sc where exists
(select 1 from studect st where sc.sno =st .sno
and st.sdept='CS')

建议多看看sql基本语法。

Answer 3

不是SELETE，是SELECT