Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //versi BI
- SELECT perk_umum, perk_text AS perkiraan, perk_kode, perk_status,
- SUM(IF(neraca_tanggal <= '2015-06-13' ,IF( perk_d_or_k = 'D',( neraca_debet - neraca_kredit ) , ( neraca_kredit - neraca_debet )), 0 )) AS saldo2
- FROM kode_perkiraan1
- LEFT JOIN mobile_neraca ON perk_kode = neraca_perkiraan
- AND perk_umum IN (4,5,6)
- GROUP BY perk_kode
- ORDER BY perk_kode
- //versi etap
- SELECT perk_umum, perk_text1 AS perkiraan, perk_kode, perk_status,
- SUM(IF(neraca_tanggal <= '2015-06-13' ,IF( neraca_d_or_k = 'D',( neraca_debet - neraca_kredit ) * perk_notasi , ( neraca_kredit - neraca_debet ) * perk_notasi), 0 )) AS saldo2
- FROM kode_perkiraan2
- LEFT JOIN mobile_neraca ON perk_kode = neraca_perkiraan
- AND perk_umum IN (4,5,6)
- GROUP BY perk_kode1
- ORDER BY perk_kode1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement