KARENA ANDA MENGGUNAKAN FUNGSI SUM() MAKA SEHARUSNYA D.NOPO JUGA DI GROUP KAN KARENA FIELD D.NOPO OLEH ANDA DITAMPILKAN DAN SELAIN ITU FIELD D.NOPO MERUPAKAN FIELD YG BERISI KARAKTER ATAU TANGGAL...AGAR TIDAK KELUAR PESAN ERROR TSB, YAITU DENGAN CARA GROUP ATAU FIELD D.NOPO JANGAN DITAMPILKAN....
--- "A. Numairullah" <[EMAIL PROTECTED]> wrote: > > Thanks 4 ur response, Tapi NOPO nya ngga mau saya > jadikan paramater GROUPing nya, bagaimana ? > > --- bonbon <[EMAIL PROTECTED]> wrote: > > > nopo nya musti di masukin di group by..... > > ----- Original Message ----- > > From: "A. Numairullah" <[EMAIL PROTECTED]> > > To: "VB Group" <[email protected]> > > Sent: Friday, January 06, 2006 3:15 PM > > Subject: [indoprog-vb] Error di Select Query > > > > > > > Dear All, > > > > > > Sy punya query sbb : > > > > > > SELECT D.NOSO, D.FABRIC, D.WARNA, D.KODEWARNA, > > > D.NOPO, D.FINISH, > > > D.TGLDLV, SUM(D.BROL) AS POBROL, > SUM(D.BKG) > > AS > > > POBKG, > > > SUM(D.RROL) AS PORROL, SUM(D.RKG) AS > PORKG, > > > SUM(D.KROL) AS POKROL, SUM(D.KKG) AS POKKG, > > > SUM(D.MROL) AS POMROL, SUM(D.MKG) AS > POMKG, > > > SUM(D.FBROL) AS SFBROL, SUM(D.FBKG) AS SFBKG, > > > SUM(D.FRROL) AS SFRROL, SUM(D.FRKG) AS > > SFRKG, > > > SUM(D.FKROL) AS SFKROL, SUM(D.FKKG) AS > > SFKKG, > > > SUM(D.FMROL) AS SFMROL, SUM(D.FMKG) AS > > SFMKG, > > > D.KODECUST, C.NAMACUST > > > FROM DYEINGS D LEFT OUTER JOIN CUSTOMERS C ON > > > D.KODECUST = > > C.KODECUST > > > WHERE D.KODECUST = "ABC" > > > GROUP BY D.NOSO, D.FABRIC, D.WARNA, D.KODEWARNA > > > ORDER BY D.NOSO > > > > > > tapi saat di run muncul error : > > > Column 'D.NOPO' is invalid in the select list > > because > > > it is not contained in either an aggregate > > function or > > > > > > the GROUP BY clause. > > > > > > Kalo ada yang mau baik hati, kasih analisa > > donk...:-/ > > > > > > > > > Thank's B4 & rgds > > > > > > > > > > > > __________________________________________ > > > Yahoo! DSL - Something to write home about. > > > Just $16.99/mo. or less. > > > dsl.yahoo.com > > > > > > > > > > > > Untuk berhenti berlangganan kirim email kosong > ke > > : > > > [EMAIL PROTECTED] > > > > > > Ikuti juga forum diskusi VB.net dengan > > > mengirim email kosong ke > > [EMAIL PROTECTED] > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > __________________________________________ > Yahoo! DSL Something to write home about. > Just $16.99/mo. or less. > dsl.yahoo.com > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
