28,390
社区成员
发帖
与我相关
我的任务
分享
select ming,[time] from
(
select distinct ming,max([time]) as [time] from
(select distinct ming,max([time]) as [time] from a group by ming
union select distinct ming,max([time]) as [time] from b group by ming) table3
group by ming
) table4
order by [time] desc
select ming,[time] from
(
select distinct ming,min([time]) as [time] from
(select distinct ming,min([time]) as [time] from a group by ming
union select distinct ming,min([time]) as [time] from b group by ming) table3
group by ming
) table4
order by [time] desc
select ming,[time] from
(
select distinct ming,min([time]) as [time] from
(select distinct ming,min([time]) as [time] from table1 group by ming
union select distinct ming,min([time]) as [time] from table2 group by ming) table3
group by ming
) table4
order by [time] desc