coba pake sql berikut moga-moga membantu
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
Maya Agnelia <[EMAIL PROTECTED]> wrote:
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:
hi guys,
maya baru gabung nih, tapi mau langsung nanya.
bagaimana sih cara memindahkan data dari tabel satu
ke tabel lain?
contoh:
ini tabel rekening
--------------------- --------- -
kode nama debet kredit
--------------------- --------- -
1101 kas 0 0
1102 fix 0 0 dst
ini tabel jurnal
--------------------- --------- --------
kode keterangan debet kredit
--------------------- --------- --------
1101 beli 500 0
3001 jual 600
1101 beli 900 0 dst
nah pertanyaanya , gimana memindahkan data yg ada
didebet tabel jurnal, tetapi data tsb dijumlahkan
terlebih dahulu berdasarkan kodenya,lalu setelah
dijumlahkan dipindahkan ke tabel rekening
dikolom debet dan sesuai dengan kode yg ada ditabel
jurnal.
mas2 yg ganteng tolongin maya yah, kasih logikanya,
atawa kalo ada contoh kodenya maya ucapkan terimakasih
banyak.
regards
maya agnelia
_____________________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Send instant messages to your online friends http://uk.messenger.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
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.
