当我的SQL语句中只有一个inner join时,它工作得很好。我尝试连接第二个表,但现在收到一个错误,指出存在语法错误(缺少运算符)。这里出了什么问题?
adsFormView.SelectCommand = "SELECT * FROM [tableCourse] INNER JOIN [tableGrade] ON [tableCourse].[grading] = [tableGrade].[id] INNER JOIN [tableCourseType] ON [tableCourse].[course_type] = [tableCourseType].[id] WHERE [prefix]='" & myPrefix & "' AND [course_number]='" & myCourseNum & "'"
https://stackoverflow.com/questions/7854969
复制相似问题