Question

一段简单的SQL 语句

两个表的字段是一样的，想同时读取两个表的内容并按照一定规则（比如发布时间）排序。
表名： TableA TableB
发布时间： posttime

Answer 1

select a.* from
(select * from TableA union all
select * from TableB) a
order by a.posttime

Answer 2

select a.*,b.* from talbeA a,tableB b
where a.某个字段值=b.某个字段值
order by a.posttime

如果posttime在b表中则写
order by b.posttime

Answer 3

select a.* from
(select * from TableA union all
select * from TableB) a
order by a.posttime

Answer 4

select * from (select * from TableA ,TableB) a order by a.posttime