新手求助-如何同时读取两个表所有字段中的数据？

#2

wangjy5002010-11-19 12:42

set rs=server.createobject("adodb.recordset")
sql="select * from music where username='"&user&"'"
rs.open sql,conn,1,3
再写个不就行了。
set rs1=server.createobject("adodb.recordset")
sql1="select * from admin where username='"&user&"'"
rs1.open sql1,conn,1,3

#3

ningzhonghui2010-11-19 13:40

谢谢wangjy500兄弟指定已成功拉！还想问一下除了这种方法，还有别的方法吗？麻烦再贴出来我也好学习一下拉！在此谢谢拉！

#4

yms1232010-11-19 15:01

select * from admin,music where admin.username='admin' and music.username='admin'

[ 本帖最后由 yms123 于 2010-11-19 15:04 编辑 ]

#5

ningzhonghui2010-11-19 15:23

回复 4楼 yms123

谢谢版主的指点同样测试成功拉！终于把我研究几天的东西给解决拉！以后要常来向你们学习拉

#6

njy230002010-11-19 15:59

回复 2楼 wangjy500

向高手请教：

请教同组物品查询的方法-我只发难题
Create  TABLE MAIN.[object_group](
[object_title] varchar(50)
,[object_para] varchar(50)
,[group_title] varchar(50)
,[group_value] varchar(50)
, Primary Key(object_title,object_para,group_title,group_value)
);

Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("桌子","红木八仙桌","品种","家具");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("桌子","红木八仙桌","材质","红木");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("桌子","红木八仙桌","包装","一类包装-大");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("茶几","红木几","品种","家具");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("茶几","红木几","材质","红木");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("茶几","红木几","包装","二类包装-中");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("桌子","平头案","品种","家具");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("桌子","平头案","材质","梨花木");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("桌子","平头案","包装","一类包装-大");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("椅子","电脑转椅","品种","办公");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("椅子","电脑转椅","包装","二类包装-中");
Insert  Into [object_group] ([object_title],[object_para],[group_title],[group_value]) Values("椅子","电脑转椅","材质","革");

[object_title] 对象名称
[object_para] 对象参数
[group_title] 组名称
[group_value] 组取值

求查询语句写法：
输入：对象名称，对象参数
输出：和输入对象至少具有两个相同组名称和组取值的其他对象列表
通俗讲，就是：至少有两个分类定义相同的其他物品

也可以扩充为：有若干个分类定义相同

#7

yms1232010-11-19 16:50

不明白6楼想得到什么？

#8

wangjy5002010-11-19 17:49

https://bbs.bccn.net/thread-217539-1-1.html
这个贴好好研究下。

新手求助-如何同时读取两个表 所有字段 中的数据 ？