select code,nama,sum(qty),ket from table group by code,nama,ket Salam Ronald Irawan Pt. Sanghiang Perkasa Gd. Graha Kirana Lt.5 Jl Yos Sudarso Kav.88 Jakarta
antony antony <[EMAIL PROTECTED]> Sent by: [email protected] 24/01/2006 01:06 PM Please respond to [email protected] To [email protected], [EMAIL PROTECTED], [EMAIL PROTECTED] cc Subject [indoprog-vb] minta bantuan.... salam, saya mau nanya,gimana ya cara hitung jumlah qty tabel saya seperti ini tabel transaksi: code nama qty ket tanggal L001 mouse 1 JL 01/01/06 L002 monitor 2 JL 01/01/06 L002 monitor 1 RJ 02/01/06 L001 mouse 1 JL 03/01/06 L003 keyboard 4 JL 01/01/06 L004 pita 1 JL 05/01/06 L002 monitor 1 JL 05/01/06 L001 mouse 1 RJ 06/01/06 L003 keyboard 1 RJ 06/01/06 L004 pita 1 JL 07/01/06 L001 mouse 5 BL 08/01/06 L002 monitor 3 BL 09/01/06 jadi saya mau kayak gini code nama qty ket L001 mouse xx JL L001 mouse xx RJ L001 mouse xx BL L002 monitor xx JL L002 monitor xx RJ L003 keyboard xx JL dst.... gimana ya pakai sql statement.soalnya kalo pakai looping itu sangat lambat sekali. --------------------------------- Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars. [Non-text portions of this message have been removed] Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links [Non-text portions of this message have been removed] Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-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/
