rsstu.Open "select student.SID,student.SEnabled,reginfo.EID
from studentinfo,reginfo
where student.SID=reginfo.SID
order by stunent.SID ",
wxmserver
指明排序的对象是哪个表的!
order by stunent.SID
注意单词之间的空格,高级语言写SQL 语句时,经常是没有用空格分离单词引起的!
from studentinfo,reginfo
where student.SID=reginfo.SID
order by stunent.SID ",
wxmserver
指明排序的对象是哪个表的!
order by stunent.SID
注意单词之间的空格,高级语言写SQL 语句时,经常是没有用空格分离单词引起的!
select studentinfo.SID,studentinfo.SEnabled,reginfo.EID
from studentinfo,reginfo
where studentinfo.SID.SID=reginfo.SID
order by studentinfo.SID
那样应该找不到
from studentinfo a,reginfo b
where a.SID=b.SID
order by a.SID