查询二个表的记录合集 select * from tbaunion select * from tbborder by date 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from (select * from 表Aunionselect * from 表B) tab order by date desc select * from tbaunion select * from tbborder by date select * into #tabfrom 表1select *into #tabfrom 表2select * from #tab order by date select*from (select*from 表A union select* from 表B)order by date desc select * from (select * from 表Aunion allselect * from 表B) s order by date desc select * from (select * from a union all select * from b) order by date desc MSSQL输入一个时间段,如何得到离这个时间段最新的数据? 急:sqlserver 2005 中ssis的导入导出问题!! sql server 中 string 数据类型的自动转换问题 100W数据库模糊查询统计搜索结果问题,请支招 百分比统计问题 取表自身一部分做关联该怎么写? 各位高手指教一条sql语句,谢谢 用sql修改字段默认值 如何使用花生壳访问ADSL网内的电脑? 我想实现分组后再排序,我是asp来的 存储过程终止语句执行的问题 遍历数据库添加默认值
select * from (
select * from 表A
union
select * from 表B
) tab order by date desc
union select * from tbb
order by date
into #tab
from 表1
select *
into #tab
from 表2
select * from #tab order by date
from (select*from 表A union select* from 表B)
order by date desc
(select * from 表A
union all
select * from 表B) s
order by date desc
from (select * from a union all select * from b)
order by date desc