jan = case when month(tanggal)=1 then
sum(harga)
end
feb = case when month(tanggal)=2 then
sum(harga)
end
from tb_m_brg
group by nama
semoga bisa membantu
----- Original Message -----
From: "delphi" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, December 28, 2004 1:53 PM
Subject: [Delphindo] report
>
> tolong bantuannya,
>
> saya punya table harga :
> Nama Tanggal Harga
> Piring 1/1/2004 1000
> Mangkok 1/1/2004 900
> Piring 5/2/2004 1000
> Mangkok 5/2/2004 1000
> Piring 2/3/2004 1100
> Mangkok 2/3/2004 900
> Piring 1/4/2004 900
> Piring 1/8/2004 900
>
>
> Saya ingin membuat report dengan format sbb :
>
> Nama Januari Februari Maret April Mei Juni Juli
> Agustus September Oktober November Desember
> Piring 1000 1000 1100 900
> 900
> Mangkok 900 1000 900
>
>
> Bisakah dibuat dengan suatu query (mysql + myodbc) ?
>
>
> Thx
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Berlangganan: [EMAIL PROTECTED]
> Stop Berlangganan: [EMAIL PROTECTED]
> Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
>
>
>
>
>
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
