如何让asp的两个数据集相加 合并成一个数据集

[还要匿名啊]

rs1和rs2
两个里的字段都一样
就只是想要他们呢合在一起
最形象的就是：rs3=rs1+rs2

里面rs1合rs2的顺序都不能变的啊

我本来想用sql 合并结果

select *
from commark
where exists( select top 10 *
from advzs where tradeid like '%机械%' and editor=gsbm and advclass='zsqyleftgjz' and passed=1 order by advorder desc)
UNION ALL
select top 10 * from commark where title like '%机械%'
很遗憾 上面说
如果语句中包含 UNION 运算符，那么 ORDER BY 子句中的项就必须出现在选择列表中。
问题好像就使在
order by advorder desc

两个问题解决任何一个都可以

[影子tec]

先建立一个两张表合集的视图，再查询

[myvicy]

select * from(select *,1 as [order]
from commark
where exists( select top 10 *
from advzs where tradeid like '%机械%' and editor=gsbm and advclass='zsqyleftgjz' and passed=1)
UNION ALL
select top 10 *,0 as [order] from commark where title like '%机械%') order by advorder,[order] desc
这样试试

[还要匿名啊]

在关键字 'order' 附近有语法错误。
报错
ASP
难道不能
rs1和rs2合并
这样就简单多了

[myvicy]

合并肯定是可以的.上面的写法原理也没错。
select * from (select 1 as [order] from commark union select 0 as [order] from commark) order by [order] desc
你可以单独测试这个句子,然后再一个一个加其他相关条件进去

[还要匿名啊]

解决了
方法是联合查询
散分吧

[还要匿名啊]

出错使没出错了 但为什么排序没了？
select comid,title
from commark
where exists( select top 10 1,1 as advorder,1 as updatetime
from advzs where tradeid like '%机械%' and gsbm=editor and advclass='zsqyleftgjz' and passed=1 order by advorder desc,updatetime desc)
我想要 COMMAR.gsbm 是根据advzs.editor 一样的顺序
为什么 exists( select top 10 1,1 as advorder,1 as updatetime
from advzs where tradeid like '%机械%' and gsbm=editor and advclass='zsqyleftgjz' and passed=1 order by advorder desc,updatetime desc)
里面的排序没其作用呢？