case when month(tanggal)=1 then
sum(harga)
end as jan,
case when month(tanggal)=2 then
sum(harga)
end as feb
from tb_m_brg
group by nama
----- Original Message -----
From: "delphi" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, December 28, 2004 2:48 PM
Subject: Re: [Delphindo] report
>
> sdh saya coba di mysql, dan error. 'Unknown column`jan` in field list.
> Apa mysql tdk support ?
>
> thx
> ----- Original Message -----
> From: fathur
> To: [email protected]
> Sent: Tuesday, December 28, 2004 1:58 PM
> Subject: Re: [Delphindo] report
>
>
> select nama ,
> 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.
