两个记录集如何合并?请高手帮忙!!

[DENGCX_OWNSOFT]

简单举个例子,我的新闻有普通、推荐和固顶两中 字段Type为1,2,3来识别
现在我想要一个Recordset,中排列顺序是先固顶 后普通和推荐
Select * From News Where Type = 3 Order By WriteTime Desc
Select * From News Where Type != 3 Order By WriteTime Desc
如何将上述两个查询的结果合并在一起？？？请高手帮忙！

[bsdog]

再来个总体查询不就没事了？
你这是等于3的也查了，不等于3的也查了
那直接再来个全部查询~~~

[超级大笨狼]

Select * From News Where Type = 3 Order By WriteTime Desc
union all
Select * From News Where Type != 3 Order By WriteTime Desc

[fafenglea]

用union可以吗？好像不行的，还是混在一起的
Select * From News Order By Type desc,WriteTime Desc
这样写的话就是 固定-推荐-普通
如果你想推荐和普通混在一起的话我也不知道

[-神仙-]

Select * From News Order By (Type = 3) , WriteTime Desc