Сверка двух таблиц по нескольким параметрам и формирование итоговых результатов

 SELECT t1.[LB1] AS 'ЛБ1_2013', COUNT (t1.[ContractNumber]) AS 'Количество_лонгированных_договора_2013', SUM(t1.[76]) AS 'Начислено_76_2013' 
FROM 
 [BD_REPORT].[dbo].[76-2013(9)] AS t1
 LEFT JOIN [BD_REPORT].[dbo].[76-2012] AS t2
 ON t1. [INSURER] = t2. [INSURER] AND t1. [Vid] = t2. [Vid] AND t2. [Object] = t1.[Object] AND t1.[RegistrationNumber] = t2.[RegistrationNumber]
WHERE t1. [DateBegin] - t2.[DateEnd] <=30 
GROUP BY t1.[LB1]

SELECT t1.LB1,  SUM(t1.[76]) AS 'Начислено_76_2013' , COUNT ([ContractNumber])
FROM [ALFASAO_REPORT].[dbo].[76-2013(9)] AS t1
WHERE EXISTS
    (SELECT * 
     FROM [ALFASAO_REPORT].[dbo].[76-2012] AS t2
     WHERE t1. [INSURER] = t2. [INSURER] AND t1. [Vid] = t2. [Vid] AND t2. [Object] = t1.[Object] AND t1.[RegistrationNumber] = t2.[RegistrationNumber])
      GROUP BY t1.[LB1]

SELECT 
YEAR (t1.[DateContract]) AS 'Год заключения' , MONTH (t1.[DateContract]) AS 'Месяц заключения', t1.lb1 AS 'ЛБ1', t1.lb2 AS 'ЛБ2', t1.lb3 AS 'ЛБ3', t1.ContractNumber AS 'Номер договора', t1.Insurer AS 'Страхователь', t1.Beneficiary AS 'Выгодопреобретатель', t1.ExternalChannel AS 'Внешний канал', t1.[RegistrationNumber] AS 'Номерной знак', t1.[SumPaymentTotal] AS 'Страховая премия по договору', SUM(t1.[76]) AS 'Начислено счет 76.1'
 
FROM [BD_REPORT].[dbo].[76-2013(11)temp] AS t1
WHERE EXISTS
 (SELECT * 
 FROM [BD_REPORT].[dbo].[76-2012] AS t2
 WHERE t1. [INSURER] = t2. [INSURER] AND t1. [Vid] = t2. [Vid] AND t2. [Object] = t1.[Object] 
 AND t1.[RegistrationNumber] = t2.[RegistrationNumber] AND t2.[ContractNumber] != t1.[ContractNumber] 
 AND t1.vid LIKE N'%транспорту, кр%' AND t1.[DateContract] BETWEEN '20130101' AND '20131231' AND t2.[DateContract] BETWEEN '20120101' AND '20121231' ) 
 
 
 
 GROUP BY YEAR (t1.[DateContract]), MONTH (t1.[DateContract]), t1.lb1, t1.lb2, t1.lb3 , t1.ContractNumber, t1.Insurer ,t1.Beneficiary, t1.ExternalChannel , t1.[RegistrationNumber], t1.[SumPaymentTotal] 
 ORDER BY YEAR (t1.[DateContract]), MONTH (t1.[DateContract])

SELECT 
YEAR (t2.[DateContract]) AS 'Год заключения' , MONTH (t2.[DateContract]) AS 'Месяц заключения',  t2.lb1 AS 'ЛБ1',  t2.lb2 AS 'ЛБ2', t2.lb3 AS 'ЛБ3', 
t1.ContractNumber AS 'Номер договора 2012',   t2.ContractNumber AS 'Номер договора 2013',  t2.Insurer AS 'Страхователь', t2.Beneficiary AS 'Выгодопреобретатель',
  t2.ExternalChannel AS 'Внешний канал', t2.[RegistrationNumber] AS 'Номерной знак', t1.[SumPaymentTotal] AS 'Страховая премия по договору 2012', 
   t2.[SumPaymentTotal] AS 'Страховая премия по договору 2013',   SUM(t2.[76]) AS 'Начислено счет 76.1 2013'
 
 
 
FROM [BD_REPORT].[dbo].[76-2012] AS t1
JOIN [BD_REPORT].[dbo].[76-2013(11)temp] AS t2
    ON t1. [INSURER] = t2. [INSURER] AND t1. [Vid] = t2. [Vid] AND t2. [Object] = t1.[Object] 
     AND t1.[RegistrationNumber] = t2.[RegistrationNumber] AND t2.[ContractNumber] != t1.[ContractNumber] 
     AND t1.vid LIKE N'%транспорту, кр%' AND t1.[DateContract] BETWEEN '20120101' AND '20121130' AND t2.[DateContract] BETWEEN '20130101' AND '20131231'   
     AND (t2.Beneficiary LIKE N'%правекс%' OR t2.externalchannel LIKE N'%правекс%')
 
    
      GROUP BY  YEAR (t2.[DateContract]), MONTH (t2.[DateContract]),  t2.lb1,  t2.lb2, t2.lb3 , t1.ContractNumber, t2.ContractNumber,  t2.Insurer ,t2.Beneficiary, t2.ExternalChannel , t2.[RegistrationNumber], t1.[SumPaymentTotal],  t2.[SumPaymentTotal]  
      ORDER BY   YEAR (t2.[DateContract]), MONTH (t2.[DateContract])