1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
select sc.codicta,sc.anomescco,sc.IDCENCO,m.DESCENCO,
'Saldo anterior'=sc.SDANCCO,
'Mov.debito'=sc.MVDBCCO,
'Mov.Credito'=sc.MVCRCCO,
'Saldo actual'=sc.SDACCCO from saldocco as sc
left outer join MAECCO as m on sc.IDCENCO=m.idcenco
where sc.anomescco between '201301' and '201302' and LEFT(sc.CODICTA,1) in ('4','5','6','7')
Union All
select sc.codicta,sc.anomescTA,' ' as IDCENCO,m.DESCcta as DESCENCO,
'Saldo anterior'=sc.SDANCta,
'Mov.debito'=sc.MVDBCta,
'Mov.Credito'=sc.MVCRCta,
'Saldo actual'=sc.SDACCta from saldocont as sc
inner join MAECont as m on sc.codicta=m.codicta
where sc.anomescta between '201301' and '201302' and LEFT(sc.CODICTA,1) in ('4','5','6','7') and m.indccocta=0
order by sc.codicta |
