On 3/8/06, Edi Susanto <
[EMAIL PROTECTED]> wrote:
Mau tanya nih mungkin pertanyaan konyol, saya baru pindah ke MySQL 3
bulan ini dari MSAccess karena akses data mulai melambat, ada beberapa
pertanyaan yang saya masih belum ketemu solusi nya, kalo di access saya
kalo ada SQL seperti ini :
select KodeBarang, SUM(IF(Mutasi='Masuk',Jumlah,0)) AS Debet,
SUM(IF(Mutasi='Keluar',Jumlah,0)) AS Kredit,
(SUM(IF(Mutasi='Masuk',Jumlah,0))-SUM(IF(Mutasi='Keluar',Jumlah,0))) AS
Saldo FROM tblkartustok group by kodebarang, saya kan cukup tulis select
KodeBarang, SUM(IF(Mutasi='Masuk',Jumlah,0)) AS Debet,
SUM(IF(Mutasi='Keluar',Jumlah,0)) AS Kredit, Debet-Kredit AS Saldo FROM
tblkartustok group by kodebarang
jadi ngga usah ngulangi sintax yang di belakang AS karena kalo mutasi
nya banyak, waduh ruwet sekali terus sintax dibelakang AS juga ngga bisa
di pake di GROUP BY ya di MySQL ?
mohon pencerahannya.....
Thx
edi susanto
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
--
Care International Indonesia
Health Department
Data Management Officer
--
Hidayat (dayat)
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
