Question

asp 多表查询

我用的是ACCESS数据库，要从school表中按gaoxiao表中的bianhao查询出相关信息，但不知道asp如何联系两个表的，麻烦高手写下代码，最好能全一点，谢谢了

Answer 1

select school.* from school,gaoxiao where school.bianhao=gaoxiao.bianhao

school.*只是一个代号,你可以替换成局枝要取出的信息的字段,如搭腊慎school.xingming,school.bianhao....,可以是多个字段,中间用逗号分隔,记得知敬要带上school这个表名

Answer 2

你做两个记录集也可以
set rs1=conn.execute "select * from gaoxiao"
set rs2=conn.execute "肢祥select * from school where bianhao="&bianhao&历键搏"亮铅"
有不明白的可以QQ:39149

Answer 3

select * from shcool inner join gaoxiao on school.bianhao=gaoxiao.bianhao

关扮虚联 school 和gaoxiao表中猛缺笑 school.bianhao和gaoxiao.bianhao这两个枝含字段相同的记录

Answer 4

select * from A,B where A.id=b.id
A表示表A
B表示表B
A.id=b.id表示两隐银余个灶滚表的搏汪连接相关的字段

Answer 5

查询的2个扮哗表用union连接参槐烂考厅明行资料： http://hi.baidu.com/ycendream/blog/item/d16ebd2ba3ae0025d52af1fc.html