refs:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6fd531d0-1276-4a6a-a63d-aafc8ced515f/combine-multiple-result-sets-into-one-xml-result-set?forum=sqlxml
sql server可以通过union来把同类型(相同列)的结果合并在一起,也可以通过join把相关表联合后在做select,但对于不相干的表,且结果类型也不一致,则只能通过其他方式来解决了,refs中的链接是很有效的参考。
select
(select count(1) from by_etor_tickets where status<5 ) as ticket_count ,
(select count(1) from by_v_etor_detail where status=1 )as etor_online_count,
(select count(1) from by_v_etor_detail where status!=1 and status!=4 ) as etor_offline_count ,
(select CONVERT(varchar(100) , getdate(), 20 )) as datetime