select a.regn as 'регномер', sum(a.iitg) as 'чистые активы', b.c3 as 'капитал', c.oitga as 'дневной оборот', a.dt as 'дата' 
from dbo.[122012b1] a, dbo.[122012_134d] b, dbo.[122012b1] c
where a.regn=b.regn 
	and a.regn = c.regn 
		and b.c1 in ('000')
			and (left(a.num_sc,1) in ('1', '2', '3', '4', '5')  and (a.a_p = '1'))
				and c.num_sc in ('30102')
group by a.regn, a.dt, b.c3, c.oitga
order by 1

select a.regn as [регномер], sum(a.iitg) as [чистые активы], b.c3 as [капитал], c.oitga as [дневной оборот], a.dt as [дата]
from dbo.[122012b1] a
join dbo.[122012_134d] b on a.regn=b.regn
join dbo.[122012b1] c on a.regn = c.regn 
where b.c1='000'
  and a.num_sc like'[12345]%'
  and a.a_p='1'
  and c.num_sc='30102'
group by a.regn, a.dt, b.c3, c.oitga
order by [регномер];

select 
   a.regn as 'регномер', 
   sum(a.iitg) as 'чистые активы', 
   b.c3 as 'капитал', 
   c.oitga as 'дневной оборот', 
   a.dt as 'дата' 
from dbo.[122012b1] a
join dbo.[122012_134d] b on b.regn=a.regn and b.c1 ='000'
join dbo.[122012b1] c on c.regn=a.regn and c.num_sc ='30102'
where a.a_p = '1' and a.num_sc like '[1-5]%' 
group by a.regn, a.dt, b.c3, c.oitga
order by 1