SELECT E.CourseID, E.Grade, S.FName, S.LName FROM Assignment_DB.ENROLLED AS E INNER JOIN Assignment_DB.STUDENT AS S ON E.StudentID=S.StudentID在用JDBC做数据检索,但是发现这个搜索语句老报错:“SQL command not properly ended.” 请问问题出在哪里呢?
换种方式试试咯 SELECT E.CourseID, E.Grade, S.FName, S.LName FROM Assignment_DB.ENROLLED E ,Assignment_DB.STUDENT S WHERE E.StudentID=S.StudentID
把语句放到SQL中单独执行看有什么结果。 实在不行改成这样:SELECT E.CourseID, E.Grade, S.FName, S.LName FROM Assignment_DB.ENROLLED AS E WITH(NOLOCK) INNER JOIN Assignment_DB.STUDENT AS S WITH(NOLOCK) ON E.StudentID=S.StudentID
SELECT E.CourseID, E.Grade, S.FName, S.LName FROM Assignment_DB.ENROLLED E ,Assignment_DB.STUDENT S WHERE E.StudentID=S.StudentID
实在不行改成这样:SELECT E.CourseID, E.Grade, S.FName, S.LName FROM Assignment_DB.ENROLLED AS E WITH(NOLOCK)
INNER JOIN Assignment_DB.STUDENT AS S WITH(NOLOCK) ON E.StudentID=S.StudentID