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