dacarica dalibor lukić bg
Član broj: 14845 Poruke: 56 212.124.181.*
|
imam 4 tabele
1. Korisnici
2. Nalozi
3. Sredstva
4. Transakcije
Kako da napravim select u upitu ali tako da:
U ovom dobijam stanja za svaki nalog i u kojoj valuti
---------------------------------------------------
SELECT
t.account,
t.ccy,
(CASE t.ccy
WHEN 'RSD' THEN t.lcy_bal
ELSE t.acy_bal
END) AS last_ball
FROM actb_history t
where t.bkg_date in
(SELECT MAX(g.bkg_date)FROM actb_history g
WHERE g.account=t.account)
------------------------------------------------------
II deo:
-------------------------------------------------------
select a.customer_name as ime, a.customer_no as custno,
b.cust_acnt as nalog,b.ccy as valuta,
sum(decode(c.DRCR_IND,'C',c.LCY_AMNT,0)) - sum(decode(c.DRCR_IND,'D',c.LCY_AMNT,0)) as balans_LCY,
sum(decode(c.DRCR_IND,'C',c.ACY_AMNT,0)) - sum(decode(c.DRCR_IND,'D',c.ACY_AMNT,0)) as balans_ACY
from tt_customer a, cust_account b, all_ac_entries c
where a.customer_type='O'
and a.customer_no=b.cust_no
and b.cust_acno=c.AC_NO
and b.ccy=c.AC_CCY
group by a.customer_name1, a.customer_no, b.cust_ac_no,b.ccy
-----------------------------------------------------------
iz prvog upita dobijem :
----------------------------
nalog valuta iznos
11111111 USD 150,00
22222222 EUR 10,12
22222222 RSD 0,00
a drugi :
------------------------------
11111111 USD 101,10
22222222 EUR 10,00
22222222 RSD 1200,25
Moje pitanje je jel mogu ova dva upita nekako da spojim i da polja koja su LCY to je RSD, saberem kao i ACY koja je strana valuta, ili vec kako?
|