高考问答木桐男爵葡萄酒:asp 问题急,在线等
来源：百度文库 编辑：高考问答 时间：2024/04/29 11:51:35
求救,急,急,急 rs.open ("select b.bid,b.buser,b.bresult,b.btype,s.sname,c.cname,ss.sname,t.tname,d.dname from stu_zs b,student s,class c,subject ss,term t,department d where b.buser=s.suser and b.cla_id=c.cid and c.dep_id=d.did and b.ter_id=t.tid "&sql_buser&" "&sql_ter_id&" "&sql_sub_id&" "&sql_cla_id&" order by b.bid desc"),conn,1,3
"&sql_buser&" "&sql_ter_id&" "&sql_sub_id&" "&sql_cla_id&" order by b.bid desc"什么作用
"&sql_buser&" "&sql_ter_id&" "&sql_sub_id&" "&sql_cla_id&" order by b.bid desc"什么作用
where b.buser=s.suser and b.cla_id=c.cid and c.dep_id=d.did and b.ter_id=t.tid "&sql_buser&" "&sql_ter_id&" "&sql_sub_id&" "&sql_cla_id&" order by b.bid desc"
这些都是条件的逻辑连接呀
不过你没有打全前后的代码：
"&sql_buser&" "&sql_ter_id&" "&sql_sub_id&" "&sql_cla_id&" order by b.bid desc"
上面的这些变量，你到前面搜索一下就可以了
六个表，服了你了，会做这种系统
"&sql_buser&" "&sql_ter_id&" "&sql_sub_id&" "&sql_cla_id&" order by b.bid desc"
什么吗？