select nama, sum(if(month(tanggal) = 1, harga, 0)) as
januri, sum(if(month(tanggal) = 2, harga, 0)) as
febuari from produk
group by nama;
depok();
--- delphi <[EMAIL PROTECTED]> wrote:
>
> tolong bantuannya (urgent) ,
>
> saya punya table Produk :
> 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 ? saya menggunakan
> mysql.
>
> thx
>
>
> [Non-text portions of this message have been
> removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion
> Toolbar.
> Now with Pop-Up Blocker. Get it for free!
>
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/i7folB/TM
>
--------------------------------------------------------------------~->
>
>
> Berlangganan: [EMAIL PROTECTED]
> Stop Berlangganan:
> [EMAIL PROTECTED]
> Keluhan Milis(Unbouncing,spam,dll):
> [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
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.
