Re: [Programmer-VB] Kenapa waktu query selalu error: Invalid use of group function?

[dwi saputro]

select nama, sum(jumlah)'total' into #data1 from tb2 group by nama

select a.nama,(a.jumlah-isnull(b.total,0))'sisa'  from tb1 a left join #data1 b 
on a.nama=b.nama

 thanks,
dwiwanto.




________________________________
From: Frangky <franklin...@gmail.com>
To: Programmer-VB@yahoogroups.com
Sent: Tuesday, June 16, 2009 11:59:14 AM
Subject: [Programmer-VB] Kenapa waktu query selalu error: Invalid use of group 
function?





Teman-teman,
Saya punya 2 tabel seperti dibawah ini:
 
Tb1 (Tabel Master)
Nama                    JUMLAH
Ani                         5000
Rudi                       3000
 
Tb2 (Tabel Transaksi)
Nama                    JUMLAH
Ani                         2000
Rudi                       100
Rudi                       2500
 
Berdasarkan kedua table diatas saya lakukan query seperti
ini:
select tb1.nama, tb1.jumlah-sum( tb2.jumlah) as jml from
tb1 inner join tb2 on tb2.nama = tb1.nama where tb1.jumlah-sum( tb2.jumlah)
<> 0 group by tb2.nama
 
Tapi selalu gagal/ error Code: 1111 Invalid use of group
function
 
Mohon bantuannya.
Terima kasih.