在ASP中如何将两次查询的结果合并起来?

[galiton]

例如:

rs1.Open "select name from table1 where age > 18"

rs2.Open "select name from talbe2 where sex = male"

现在需要把两次查询的结果放在一个表格中, 并且不能有重复的字段.

请给我代码好吗?
谢谢

[maxid]

用两组数组保存起来啊

[galiton]

能给我代码吗?

[tater]

rs.Open(select distinct * from (select name from table1 where age> 18 union select name from talbe2 where sex = male))

[希偌]

rs1.Open "select name from table1 where age>18 union select name from talbe2 where sex='male'"
采用union联合查询！