select SUM(CASE month(a.tgl) WHEN 1 THEN a.qty ELSE 0 END ) as jan,
SUM(CASE month(a.tgl) WHEN 2 THEN a.qty ELSE 0 END ) as feb,
dst. (coba ndiri yah..)
Liung's
www.apktntajd.com (Ape Kate Ente Aje Deh!)
Ndy wrote:
>
>
> Coba begini :
>
> Buat tabel baru(misal nama tblBulan) yang berisi data bulan 1 s/d 12
>
> select tblBulan.bulan,sum(transaksi.qty) as Quality from
> transaksi,tblBulan where month(transaksi.tgl)=tblBulan.bulan group by
> tblBulan.bulan order by tblBulan.bulan
>
> Met Nyoba....
>
>
>
> ----- Original Message -----
> *From:* ::Agus Sudana:: <mailto:[EMAIL PROTECTED]>
> *To:* [email protected] <mailto:[email protected]>
> *Sent:* Wednesday, April 18, 2007 9:47 AM
> *Subject:* Re: [Programmer-VB] query SQL transaksi perbulan selama setahun
>
> dear mas tony,
> terima kasih bngt..
> tapi,klo blh, itu hnya menampilkan per bln jan saja..
> agar menampilkan semua qty per bulan (jan, feb,.. dst.) ky apa ya mas..?
> regards,
>
> (
> .
>
