合并两个表的两个记录集到一个记录集，sql怎样写

[bighai]

sql1:
select c_title from t_news where c_ishot=1 order by c_date desc
sql2:
select c_title from t_affiche where c_ishot=1 order by c_date desc

现在我想把它这两个语句合并起来,并按时间(c_date)排序,有劳各位老大?

[bighai]

补充一点,只需要查c_title就可以了

[子陌红尘]

select c_title from t_news where c_ishot=1
union all
select c_title from t_affiche where c_ishot=1
order by c_date desc

[zjcxc]

select c_title from(
select c_title,c_date from t_news where c_ishot=1
union all
select c_title,c_date from t_affiche where c_ishot=1
)a order by c_date desc

[yingqing]

select c_title from(
select c_title,c_date from t_news where c_ishot=1
union all
select c_title,c_date from t_affiche where c_ishot=1
)a order by c_date desc

[bighai]

<%
sqltext5=" select c_title from(
select c_title,c_date from t_news where c_ishot=1
union all
select c_title,c_date from t_affiche where c_ishot=1
)a order by c_date desc "

set rs3=server.createobject("adodb.recordset")
rs3.open sqltext5,conn,1,1
%>

多谢几位大哥,按照你们的意民,我写一个asp查询语句,为什么系统提示:

Microsoft VBScript 编译器错误 错误 '800a0409'

未结束的字符串常量

/index2.asp，行311

sqltext5=" select c_title from(
-------------------------------^

不知道是哪里的原因?

[bighai]

不过,按照邹建大哥的语句,在数据库的查询分析器里面可以查询,但为什么不能用在asp语句里面,奇怪!我想一定有人会解决的!

[RainYang]

asp是可以执行的，你查查有没有地方写错

[vitas]

注意加上换行符。

[vitas]

/////////学艺不精就别出来害后辈/////////
select c_title from t_news where c_ishot=1
union all
select c_title from t_affiche where c_ishot=1
order by c_date desc