d> tolong bantuannya (urgent) , Saya ingin membuat report dengan
d> Bisakah dibuat dengan suatu query ? saya menggunakan mysql.
Coba cara cepat tanpa dipikir2 lagi, kembangin hingga lengkap yak:
select a.nama,
(select sum(harga) from barang where nama = a.nama and month(tanggal)=1) as Januari,
(select sum(harga) from barang where nama = a.nama and month(tanggal)=2) as Februari,
(select sum(harga) from barang where nama = a.nama and month(tanggal)=3) as Maret
from barang a
group by 1
Tertanda,
Oguds [36856104]
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.
