select No, Nama_Brg, Type, sum(in - out) as soh from tablenya_stock group by No, Nama, Type
> > ma kasih bung ronald dan bung mamadh > atas responnya.. querynya bener jitu > > ko boleh masih ada satu lage neh > > No nama brg in out type > 1 abc 2 0 A > 2 cde 0 5 A > 3 abc 0 1 A > 4 abc 6 0 B > 5 cde 8 0 A > > hasilnya > > no nama brg type soh > 1 abc A 1 > 2 abc B 6 > 3 cde A 3 > > querynya gimana yachh > > best regards > > Ali Akbar > > Ronald Irawan > <[EMAIL PROTECTED] To: [email protected] > <mailto:Programmer-VB%40yahoogroups.com> > com> cc: > Sent by: Subject: Re: [Programmer-VB] tanya query lage nih ( lanjutan ) > [EMAIL PROTECTED] > ogroups.com > > > 07/13/2006 02:27 > PM > Please respond to > Programmer-VB > > > > select nama_brg,sum(in)-sum(out) as SOH from tablenya group by nama_brg > > Salam > Ronald Irawan > Pt. Sanghiang Perkasa > Gd. Graha Kirana Lt.5 > Jl Yos Sudarso Kav.88 > Jakarta > > [EMAIL PROTECTED] <mailto:akbar-kmi%40khi.co.jp> > Sent by: > [EMAIL PROTECTED] To > s.com [EMAIL PROTECTED] > roups.com > 13/07/2006 02:09 PM cc > > Please respond to Subject > [EMAIL PROTECTED] [Programmer-VB] > roups.com tanya query lage nih > ( lanjutan ) > > > > > > > > > Assalamuaikum > mas caca dan yg lainya > saya punya tabel > > No nama brg in out > 1 abc 2 0 > 2 cde 0 5 > 3 abc 0 1 > 4 abc 6 0 > 5 cde 8 0 > > menjadi > > no nama brg soh > 1 abc 7 > 2 cde 3 > > gimana querynya yachh > > best regards > > Ali Akbar > > Wahana Programmer Groups Links > > Yahoo! Groups Links > > 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/
