[Programmer-VB] Query di VB dg database Access

[Eko]

saya ada buat query di vb sbk:   select tbdetail.kodebrg,tbbarang.Nama,sum(tbdetail.jumlah) as laris from tbdetail left join tbbarang on tbdetail.kodebrg = tbbarang.kodebrg group by tbdetail.kodebrg order by laris desc   kenapa selalu muncul Preview : -2147217887 - Tou tried to execute a query that does not include the specified _expression_ 'Nama' as part of an aggregate function   struktur tabel di ms access nya sbk: TbBarang (KodeBrg,Nama,HargaBeli,HargaJual) TbDetail (NoNota,KodeBrg,HargaJual,Jumlah)   padahal klo saya tes di mysql front, bisa jalan   __._,_.___ 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. __,_._,___