Объеденить запрос. Ошибка "количество таблиц более 50"

[~>>>Dron<<<~]

Есть запрос, который по отдельности работает, но мне нужно его объеденить. при добавлении ещё одного запроса начала выдавать ошибку что число таблиц в запросе не может быть болше 50.

Пытался исправить пробовал разные варианты.

Подскажите пожалуйста

Запрос:
(сам запрос правильный, нужно как то может сделать общий From (они одинаковые) пробывал, не получается)

SELECT T1.fiztonn_dr_met, T1.usl_tonn_dr_met, 
       T2.usl_tonn, T2.fiztonn, 

       T3.fiztonn_dr_met_br2, T3.usl_tonn_dr_met_br2, 
       T4.usl_tonn_br2,T4.fiztonn_br2,

       T5.fiztonn_dr_met_br3, T5.usl_tonn_dr_met_br3,
       T6.usl_tonn_br3,T6.fiztonn_br3,

SUM(T1.fiztonn_dr_met+T2.fiztonn) as sum_fiz_tonn_dr_met,
SUM(T2.usl_tonn+T1.usl_tonn_dr_met) as sum_usl_tonn_dr_met,

SUM(T3.fiztonn_dr_met_br2+T4.fiztonn_br2) as sum_fiz_tonn_dr_met_br2,
SUM(T3.usl_tonn_dr_met_br2+T4.usl_tonn_br2) as sum_usl_tonn_dr_met_br2,


SUM(T5.fiztonn_dr_met_br3+T6.fiztonn_br3) as sum_fiz_tonn_dr_met_br3,
SUM(T5.usl_tonn_dr_met_br3+T6.usl_tonn_br3) as sum_usl_tonn_dr_met_br3

FROM 



  (select isnull(sum(weight_calc),0) as usl_tonn_dr_met,isnull(sum(weight_fact),0) as fiztonn_dr_met
from nazn,req,prod,oper,unit

where  
nazn.nazn_id = req.nazn_id 
and req.req_id = prod.req_id 
and unit.unit_id=prod.unit_id and unit.prod_code='ТРАВЛ' 
and oper.op_id=prod.op_prod and  oper.op_code='NTA' and


 prod.thick<2.2 and nazn.pr_surf NOT 
IN ('I')
and dbo.AF_CALC_BRIGADA_12(Date_IN)=1 
 and date_in>'2014-09-03 00:00:00'
 and  date_in<'2014-09-03 23:59:59'

   ) T1,

  (SELECT isnull(sum(weight_calc),0) as usl_tonn,isnull(sum(weight_fact),0) as fiztonn
 from nazn,req,prod,oper,unit
 where
nazn.nazn_id = req.nazn_id 
and req.req_id = prod.req_id 
and unit.unit_id=prod.unit_id and unit.prod_code='ТРАВЛ' 
and oper.op_id=prod.op_prod and  oper.op_code='NTA'  and

 prod.thick<2.2 and nazn.pr_surf='I' and 
dbo.AF_CALC_BRIGADA_12(Date_IN)=1 
 and date_in>'2014-09-03 00:00:00'
 and  date_in<'2014-09-03 23:59:59'

) T2,

  (select isnull(sum(weight_fact),0) as fiztonn_dr_met_br2,isnull(sum(weight_calc),0) as 

usl_tonn_dr_met_br2
from nazn,req,prod,oper,unit
where 
nazn.nazn_id = req.nazn_id 
and req.req_id = prod.req_id 
and unit.unit_id=prod.unit_id and unit.prod_code='ТРАВЛ' 
and oper.op_id=prod.op_prod and  oper.op_code='NTA'  and
prod.thick<2.2 and nazn.pr_surf NOT 
IN ('I')

and dbo.AF_CALC_BRIGADA_12(Date_IN)=2 
 and date_in>'2014-09-03 00:00:00'
 and  date_in<'2014-09-03 23:59:59'

   ) T3,

  (SELECT isnull(sum(weight_calc),0) as usl_tonn_br2,isnull(sum(weight_fact),0) as fiztonn_br2
 from nazn,req,prod,oper,unit
 where
nazn.nazn_id = req.nazn_id 
and req.req_id = prod.req_id 
and unit.unit_id=prod.unit_id and unit.prod_code='ТРАВЛ' 
and oper.op_id=prod.op_prod and  oper.op_code='NTA' and
  prod.thick<2.2 and nazn.pr_surf='I' 
and dbo.AF_CALC_BRIGADA_12(Date_IN)=2 
 and date_in>'2014-09-03 00:00:00'
 and  date_in<'2014-09-03 23:59:59'
   ) T4,
 (select isnull(sum(weight_fact),0) as fiztonn_dr_met_br3,isnull(sum(weight_calc),0) as 

usl_tonn_dr_met_br3
from nazn,req,prod,oper,unit
where 
nazn.nazn_id = req.nazn_id 
and req.req_id = prod.req_id 
and unit.unit_id=prod.unit_id 
and unit.prod_code='ТРАВЛ' 
and oper.op_id=prod.op_prod and  oper.op_code='NTA' and
prod.thick<2.2 and nazn.pr_surf NOT 
IN ('I')
and dbo.AF_CALC_BRIGADA_12(Date_IN)=3 
 and date_in>'2014-09-03 00:00:00'
 and  date_in<'2014-09-03 23:59:59'

   ) T5,

  (SELECT isnull(sum(weight_calc),0) as usl_tonn_br3,isnull(sum(weight_fact),0) as fiztonn_br3
 from nazn,req,prod,oper,unit
 where
nazn.nazn_id = req.nazn_id 
and req.req_id = prod.req_id 
and unit.unit_id=prod.unit_id and unit.prod_code='ТРАВЛ' 
and oper.op_id=prod.op_prod and  oper.op_code='NTA' and
 prod.thick<2.2 and nazn.pr_surf='I' 
and dbo.AF_CALC_BRIGADA_12(Date_IN)=3
 and date_in>'2014-09-03 00:00:00'
 and  date_in<'2014-09-03 23:59:59'
   ) T6

[Аватар]

case when не знаешь что-ли? Там же одни и те же таблицы и условия отбора почти одинаковые. Отличия в casе when и суммируй. На дату коряво, лучше
date_in>='2014-09-03' and date_in<'2014-09-04'

[~>>>Dron<<<~]

Спасибо, разобрался сделал))