select * from
(select A_Name as name,A_AddTime as date,'A表' as 表名 from A
union all
select B_Name as name,B_AddTime as date,'B表' as 表名 from B
union all
select C_Name as name,C_AddTime as date,'C表' as 表名 from C
) aa order by date
[Quote=引用 1 楼 ssp2009 的回复:]
SQL code
select * from
(select A_Name as name,A_AddTime as date from A
union all
select B_Name as name,B_AddTime as date from C
union all
select C_Name as name,C_AddTime as date from C
) a……
[/Quote]
[Quote=引用 1 楼 ssp2009 的回复:]
SQL code
select * from
(select A_Name as name,A_AddTime as date from A
union all
select B_Name as name,B_AddTime as date from C
union all
select C_Name as name,C_AddTime as date from C
) a……
[/Quote]
select * from
(select A_Name as name,A_AddTime as date from A
union all
select B_Name as name,B_AddTime as date from C
union all
select C_Name as name,C_AddTime as date from C
) aa order by date