消息 102，级别 15，状态 1，第 7 行

[nana678]

Insert into TS
select *
from student
where sno in
(select Sno
from sc
　　　　　　　　　　　GROUP BY Sno
having max(grand)<60
)

消息 102，级别 15，状态 1，第 7 行
'　' 附近有语法错误。

[--小F--]

Insert into TS select * from student where sno in  (select Sno from sc GROUP BY Sno having max(grand)<60)  

[--小F--]

不知道你哪里有半角全角

[hllfl]

--难道是空格原因

Insert into TS  
  select *  
  from student
  where sno in  
  (select Sno
  from sc 
  GROUP BY Sno  
  having max(grand)<60
  )  

[叶子]

Insert into TS  
  select *  
  from student
  where sno in  
  (select Sno
  from sc GROUP BY Sno  
  having max(grand)<60
  )  

在你的group by 前面有个全角空格。

[nana678]

你们太厉害啦啊我应该早一点加入你们

[lidongfei123]

楼主的回复搞笑！