mysql 多表查询并排序

select t.authorid,t.author,COUNT(t.authorid) AS authornum from(select authorid,author,time from 表1union allselect authorid,author,time from 表2) twhere t.time >$time GROUP BY t.authorid,t.author ORDER BY authornum DESC

基本就这样。表名你换成你自己的表名，我这里分别用表1和表2表示的

select * form (

  select * from 表A

  union all

  select * form 表B

) t order by t.评论时间 desc

这样你试试

---