select No, Nama_Brg sum(in - out) as soh
from tablenya_stock
group by No, Nama
[EMAIL PROTECTED] wrote:
>
> 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
<*> 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/
