Re: [Programmer-VB] Query di VB dg database Access

[Padu Arsana iW]

Halo Eko,

Kalo gak salah eko ada yang kelupaan.

 

Select tbdetail.kodebrg,tbbarang.Nama,sum(tbdetail.jumlah) as laris from tbdetail left join tbbarang on tbdetail.kodebrg = tbbarang.kodebrg group by tbdetail.kodebrg,tbbarang.Nama order by laris desc

 

Regards

Padu Arsana iW

 

 

Eko <[EMAIL PROTECTED]> wrote:

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

 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com __._,_.___

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.

---

__,_._,___