SELECT CODE_B,ACCOUNT,YEAR,SUM(AMOUNT_A),SUM(AMOUNT_R) FROM (SELECT A.`CODE_B`, A.`ACCOUNT`, A.`YEAR`, A.`AMOUNT` AS AMOUNT_A, '0' AS AMOUNT_R FROM `Anggaran` A WHERE A.`CODE_B`='2000000' AND A.`ACCOUNT`='722121' UNION SELECT R.`CODE_B`, R.`ACCOUNT`, R.`YEAR`, R.`AMOUNT_BALANCE` AS AMOUNT_R, '0' AS AMOUNT_A FROM `Realisasi` R WHERE R.`CODE_B`='2000000' AND R.`ACCOUNT`='722121') GROUP BY `CODE_B`, `ACCOUNT`, `YEAR`
On Sun, 17 Jul 2005 20:34:56 -0700 (PDT) joseph jonathan <[EMAIL PROTECTED]> wrote: > 2 table nya di join, lalu field nya pake function sum > trus pake grouping dan pake left(periode,1,4) > > --- siswanto <[EMAIL PROTECTED]> wrote: > >> met sore semuanya, >> >> mohon dibantu aku ada masalah dg SQL command, >> TABEL A >> account period amount_A >> 721 200501 1000 >> 721 200502 2000 >> 721 200503 3000 >> 721 200504 4000 >> 721 200505 5000 >> 721 200506 6000 >> 721 200507 7000 >> 721 200508 8000 >> 721 200509 9000 >> 721 200510 10000 >> 721 200511 11000 >> 721 200512 12000 >> >> TABEL B >> account period amount_B >> 721 200501 3000 >> 721 200502 2000 >> 721 200503 1000 >> >> hasil yg aku inginkan adalah sbb: >> account period amount_A amount_B >> 721 200501 78000 6000 >> >> demikian semoga mengerti apa yg aku maksudkan dan >> terima kasih >> tanggapannya. >> >> siswanto >> >> >> >> >> >> Untuk keluar dari millis ini, kirim email kosong ke: >> [EMAIL PROTECTED] >> >> >> Yahoo! Groups Links >> >> >> [EMAIL PROTECTED] >> >> >> >> >> > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection >around > http://mail.yahoo.com > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > Yahoo! Groups Links > > > > > > ======================================================================================== Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah Jawa Timur. Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN (467826) ======================================================================================== Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
