自己写的多表联合查询，统计，行变列

  select trycord.*,b.*  from 

(select top 2 * from RemoteTryRecord where  id > 

     ( select isnull(max(id),0) from 

            (select top 2 id from RemoteTryRecord where  data between '2014-12-03 00:00:00' and '2016-01-01 00:00:00'    order by id  )  c 

     ) 

order by id )as trycord 

left join 

(select count ( distinct useaddress)as addresscount  ,count (*) as  allcount , UseOperateId ,sum (case when ControlResult=1 then 1 else 0 end) as SuccessCount,sum (case when ControlResult=2 then 1 else 0 end) as failecount
   	from 
		(select  distinct 操作票表.fzaddr as fzaddr,操作票表.nodeaddr,操作票表.OperateId as UseOperateId,设备表.address as useaddress ,操作票表.ControlResult as ControlResult
		from 操作票表,设备表 where 操作票表.fzaddr = 设备表.fzaddr and 操作票表.nodeaddr = 设备表.nodeaddr
		) as a 
    	GROUP BY UseOperateId  ) b


 on trycord.OperateId=b.UseOperateId 

自己写的多表联合查询