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

Tue, 06 Jun 2006 23:28:45 -0700

SQL pertama yang anda buat terdapat dua group,yaitu kodebrg dan Nama sehingga group by-nya berdasarkan 2 fields tsb.

Smoga membantu dan maaf bila saya salah.

 

 

From: [email protected] [mailto:[email protected]] On Behalf Of Eko
Sent: Wednesday, June 07, 2006 11:43
To: [email protected]
Subject: [Programmer-VB] Query di VB dg database Access

 

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



__,_._,___

Kirim email ke