string dissql = "select stu_Information.StudentName, stu_Information.StudentSex, stu_Information.StudentNumbe, stu_Academe.AcademeName,"
+ " stu_Major.MajorName, stu_Dorm.DormName, stu_Dorm.DormPhone, stu_Dorm.DormPersonNum, stu_Grade.GradeNumber,"
+ " stu_Information.CellPhone, stu_Information.Email, stu_Information.BBSID From (((stu_Information INNER stu_Academe ON stu_Information.AcademeID=stu_Academe.AcademeID)"
+ " INNER JOIN stu_Major ON stu_Information.MajorID=stu_Major.MajorID) INNER JOIN stu_Dorm ON stu_Information.DormID=stu_Drom.DormID)"
+ " INNER JOIN stu_Grade ON stu_Information.GradeID=stu_Grate.GradeID Order by stu_Information.StudentAddTime Desc";
报on附近有语法错误??不知道那里出错了!
+ " stu_Major.MajorName, stu_Dorm.DormName, stu_Dorm.DormPhone, stu_Dorm.DormPersonNum, stu_Grade.GradeNumber,"
+ " stu_Information.CellPhone, stu_Information.Email, stu_Information.BBSID From (((stu_Information INNER stu_Academe ON stu_Information.AcademeID=stu_Academe.AcademeID)"
+ " INNER JOIN stu_Major ON stu_Information.MajorID=stu_Major.MajorID) INNER JOIN stu_Dorm ON stu_Information.DormID=stu_Drom.DormID)"
+ " INNER JOIN stu_Grade ON stu_Information.GradeID=stu_Grate.GradeID Order by stu_Information.StudentAddTime Desc";
报on附近有语法错误??不知道那里出错了!
解决方案 »
- 急求winform 制作安装程序附加sql sever 2000数据库
- 事件的奇怪运行顺序 ,请大家帮忙看下
- C# 怎么在两个盘之间拷贝目录?
- 如何实现鼠标穿透
- 各个TablePage上TextBox控件太多,TablePage之间切换的时候发生短暂的延迟与控件图像重叠,怎么解决?
- 高分求助,c# winform 中使用winsock控件,为什么调用getdata方法不能接受客户端传来的数据。
- 我 VS 联想
- 求用C#来编一个简单的程序啊
- LisrView 添加项到指定的列和指定的组?
- targetDataSet.Merge(originaldataset)方法用后targetDataSet的rowstate怎么不变啊?
- 问题: dragObjp.innerHTML=Map.Read(zgid,dragObj.style.left,dragObj.style.top,image,imgid).value;
- .net解析Html页面
---》
少个Join吧