Coba :
update rekening set a.debet = b.debet,
a.kredit=b.kredit
from rekening a , (Select kode,sum(debet)
debet,
sum(kredit) kredit
from jurnal group by kode) b where a.kode=b.kode
atau
update 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
Rudy Tanaga <[EMAIL PROTECTED]> wrote:
Coba :
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.
Yahoo! Music Unlimited - Access over 1 million songs. Try it free. __._,_.___
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
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
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.
