sql = "select [课程].*,[选课_父表].[成绩], [选课_父表].[学生ID],[选课_父表].[选修时间] "
sql = sql & " from ([课程]left join[选课_父表]on [课程].[课程ID]=[选课_父表].[课程ID]) left join [学生名册] on [选课_父表].[学生ID] = [学生名册].[学生ID] "sql = sql & " where 学生ID=" & Text1.Text
sql = sql & " from ([课程]left join[选课_父表]on [课程].[课程ID]=[选课_父表].[课程ID]) left join [学生名册] on [选课_父表].[学生ID] = [学生名册].[学生ID] "sql = sql & " where 学生ID=" & Text1.Text
那个rs2是一个记录集合,Where 后面的 rs2![学生ID]=Text1[0].Text到底应该怎么表达???
rs2.filter = "学生ID=" & Text1.Text
rs2就是所有学生的所有选修课情况的记录集合(是通过对
[课程]left join[选课_父表]on [课程].[课程ID]=[选课_父表]……得到的)
sql = sql & " where [学生ID]='" & Text1.Text & "'"if it is a nubmer, then
sql = sql & " where [学生ID]=" & Text1.Text