sql语句查询多个表

Question

我现在有四张表，表结构不同，都是时间列，需要根据时间排序四张表的信息然后展示出来，那位大神给个思路，demo什么的。

第二个问题。。

(select plId as ID,plUserId as UserId,plTime as Times,'publish' as 'Staus' from publish ) as t1,

(select id as ID,userId as UserId,logTime as Times,'log' as 'Staus' from [log]) as t2

 

可不可以让t1 与t2的 列合并起来 然后根据时间排序

求指点

Answer 1

select plId as ID,plUserId as UserId,plTime as Times,'publish' as 'Staus' from publish ) as t1 UNION ALL select id as ID,userId as UserId,logTime as Times,'log' as 'Staus' from [log]) as t2 这样就可以了啊。

Answer 2

大叔正解。

Answer 3

需要每个表都展示所有列的数据吗？ 对于t1与t2合并，大叔的回答就ok了~

Answer 4

使用视图。