select * from ( (select ID,messageTitle,messageContent,time,bits from 表1 where time='6。2' order by bits desc limit 2) union all (select ID,messageTitle,messageContent,time,bits from 表2 where time='6。2' order by bits desc limit 2) union all (select ID,messageTitle,messageContent,time,bits from 表3 where time='6。2' order by bits desc limit 2) ) t order by bits desc limit 2
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
表1: ID,messageTitle,messageContent,time,bits(浏览次数);
表2: ID,messageTitle,messageContent,time,bits(浏览次数),zone(地区);
表3: ID,messageTitle,messageContent,time,bits(浏览次数),zone(地区),formId(版块ID)当时为了便于管理就分3个表保存的,现在要从三个表的合集里查询当天浏览次数最多的信息就比较麻烦了,楼上的大哥给解决下吧,谢谢。
2,表1第二条标题,表1第二条内容,2009.6.2,10 ;表2数据:1,表2第一条标题,表2第一条内容,2009.6.1,5,370100 ;
2,表2第二条标题,表2第二条内容,2009.6.2,10,370200 ;表3数据:1,表3第一条标题,表3第一条内容,2009.6.1,5 ,370100 ,1;
2,表3第二条标题,表3第二条内容,2009.6.1,10 ,370200 ,1;如果现在时6.2号,就要查询出6。2号浏览次数最多的信息:如果要2条的话,就会出现下面的结果: 2,表1第二条标题,表1第二条内容,2009.6.2,10 ; 2,表2第二条标题,表2第二条内容,2009.6.2,10 ;
(
(select ID,messageTitle,messageContent,time,bits
from 表1
where time='6。2'
order by bits desc limit 2)
union all
(select ID,messageTitle,messageContent,time,bits
from 表2
where time='6。2'
order by bits desc limit 2)
union all
(select ID,messageTitle,messageContent,time,bits
from 表3
where time='6。2'
order by bits desc limit 2)
) t
order by bits desc limit 2