我需要往gridview里绑定数据,现在语句如下:
SELECT Elect.stuID, Student.stuName, Elect.Score FROM Elect INNER JOIN Student ON Elect.stuID = Student.stuID WHERE (Elect.courceID = @courceID)现在我需要在把Homework表里的uploadFile 也绑定进去 homework表里有stuID,homework,uploadFile,其中要求
Elect.stuID = Student.stuID=homework.stuID
SELECT Elect.stuID, Student.stuName, Elect.Score FROM Elect INNER JOIN Student ON Elect.stuID = Student.stuID WHERE (Elect.courceID = @courceID)现在我需要在把Homework表里的uploadFile 也绑定进去 homework表里有stuID,homework,uploadFile,其中要求
Elect.stuID = Student.stuID=homework.stuID
FROM Elect
INNER JOIN Student ON Elect.stuID = Student.stuID
INNER JOIN Homework ON Elect.stuID = homework.stuID
WHERE (Elect.courceID = @courceID)
谢谢你
顺便能告诉我一下
WHERE (Elect.courceID = @courceID)里面的@的意思么?