sorry mas lupa ngasih tau dbmsnya. maya menggunakan access sbg databasenya.
sekali lagi makasih ya mas CaCa > mas caca ini pesan errornya: > > syntax error(missing operator) in query expression > b.kredit from rekening a > > thanks mas atas bantuanya > > > regards > maya > > --- thakin Caca <[EMAIL PROTECTED]> wrote: > > > DBMS pake apa yah ?, saya coba pake SQL 2000, > > running kok, dicoba aja sql di bawah ini, klo > belum > > berhasil kirim errornya nanti tak analisa, ok > > > > update rekening set debet = b.debet, > > kredit=b.kredit > > from rekening a , (Select kode,sum(debet) as > debet, > > sum(kredit) as kredit > > from jurnal group by kode) b where a.kode=b.kode > > > > > > Send instant messages to your online friends > > http://uk.messenger.yahoo.com > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer 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/
