Coba query ini :
SELECT nm_buah, SUM(jml) as jml1, SUM(harga) as harga 1 INTO Tabel_Barang_view from Tabel_Barang GROUP BY nm_buah Best Regards, _____ From: McBoenBoen [mailto:[EMAIL PROTECTED] Sent: 31 Mei 2007 19:22 To: [email protected]; Waroeng VB; [EMAIL PROTECTED] Subject: [indoprog-vb] query pengelompokan dear all Vbers, mohon pencerahannya, bagaimana caranya query memindahkan record dari tabel Barang ke tabel barang_vew dengan pengelompokan berdasarkan nama buah dan jumlahnya ditotal contoh: Tabel Barang nm_buah jml harga Jeruk 20 200 Apel 11 100 Nanas 22 200 Anggur 33 300 Jeruk 20 200 Apel 11 100 Nanas 22 200 Anggur 33 300 hasilnya dimasukkan ke tbale Barang_view dengan hasil sepeti ini: Jeruk 40 400 Apel 22 200 Nanas 44 400 Anggur 66 600 database access 2003 terimakasih atas jawabannya. salam,, mc --------------------------------- Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
