看看这个sql语句

Select    
  (select   count(ExamStudent_ID)   as   n   from   T_EnterExamInfo   b   where   Year_ID   =   10and   b.Subject_ID   =   T_Subject.Subject_ID   and   OrganLevel_ID   =   4and   Department_ID   =   3and   ExamTimes_ID   =   2)   as   StuExamNum,  
  (Select   count(Student_Name)   as   h   from   T_Student   where   School_ID   =   3   and   Year_ID   =   10)   as   StuNum,  
  StuExamNum/StuNum   as   bishu,Subject_Name    
  from   T_Subject   where   Subject_ID   in   (select   Subject_ID   from   T_Department_Subject    
  where   Year_ID   =   10and   Department_ID   =   3)  
   
  为什么这个语句在access里可以用，在sql中确不可以用呢？  
  在sql抱错：stuexamnum,stunum列名无效  
   
  到底怎么改呢？谢谢各位了 问题点数：20、回复次数：1Top

1 楼Lcindep110（Descovering YourSelf）回复于 2006-03-21 17:25:26 得分 20

Select    
  (select   count(ExamStudent_ID)   as   n   from   T_EnterExamInfo   b   where   Year_ID   =   10and   b.Subject_ID   =   T_Subject.Subject_ID   and   OrganLevel_ID   =   4and   Department_ID   =   3and   ExamTimes_ID   =   2)   as   StuExamNum,  
  (Select   count(Student_Name)   as   h   from   T_Student   where   School_ID   =   3   and   Year_ID   =   10)   as   StuNum,Subject_Name    
  from   T_Subject   where   Subject_ID   in   (select   Subject_ID   from   T_Department_Subject    
  where   Year_ID   =   10and   Department_ID   =   3)  
  或许你可以先用这个创建一个view  
  然后再用   select   StuExamNum/StuNum   as   bishu   from   yourview  
  Top

相关问题

• stuexamnum
• stunum
• subject
• department
• student
• year
• from t
• where
• count
• select

• 帖主：nanhaoff
• Lcindep110

• CSDN .NET频道
• .NET类图书
• C#类图书
• .NET类源码下载