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 <*> 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/
