pdate rekening set a.debet = b.debet,
> > a.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
Maya Agnelia <[EMAIL PROTECTED]> wrote:
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 <sudden_poniq@yahoo.com > 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
Want to be your own boss? Learn how on Yahoo! Small Business. __._,_.___
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
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
