为什么要用循环,SQL语句不能解决?
你的意思是不是把专业表的每个记录都取出来,然后再到课程表里去找相关的记录?
select major.* ,subject.subname from major left outer join subject on major.majid=subject.myjid
还是把课程表里有专业表记录的都取出来?
select major.*,subject.subname from major,subject where major.majid=subject.majid
难道就不能像ASP中一样??先从专业表中取出记录,然后循环1,根据专业ID到课程表中取相关记录,然后循环2!
set rsSub = Conn.execute("select * from Major")
Do while not rsMajo.eof
Response.write rsMajo("MajName")
set rsSub = Conn.execute("select * from Subject where MajID="rsMajo("ID"))
Do while not rsSub.eof
Response.write rsSub("SubName")
rsSub.Movenext
Loop
rsMajo.MoveNext
Loop