setau gue klo di SQL Server field yang di group by harus sama dengan field yang di select CMIWW
Dhaman frans sanjaya wrote: > Hi friends,saya baru gabung nih.. > Saya ada kendala dalam menampilkan report di Visual FoxPro dari query > dibawah ini: > > ---------------------------------------------------------- > select ms_wilayah.nm_wil, ms_lingkungan.nm_ling,; > (select count(tr_hkeluarga.id_kel) FROM tr_warga) as keluarga,; > (select count(tr_warga.id_warga) FROM tr_warga; > where tr_warga.jns_klmn ='L' AND tr_warga.id_ling = > ms_lingkungan.id_ling) as laki,; > (select count(tr_warga.id_warga) FROM tr_warga; > where tr_warga.jns_klmn ='P' and tr_warga.id_ling = > ms_lingkungan.id_ling) as perempuan,; > (select count(tr_warga.id_warga) FROM tr_warga; > where tr_warga.id_didik ='02' and tr_warga.id_ling = > ms_lingkungan.id_ling) as sd,; > (select count(tr_warga.id_warga) FROM tr_warga; > where tr_warga.id_didik ='03' and tr_warga.id_ling = > ms_lingkungan.id_ling) as smp,; > (select count(tr_warga.id_warga) FROM tr_warga; > where tr_warga.id_suku ='01' and tr_warga.id_ling = > ms_lingkungan.id_ling) as jawa,; > (select count(tr_warga.id_warga) FROM tr_warga; > where tr_warga.id_suku ='02' and tr_warga.id_ling = > ms_lingkungan.id_ling) as sunda; > >From tr_warga; > left join ms_wilayah on tr_warga.id_Wil = ms_wilayah.id_wil; > left join ms_lingkungan on tr_warga.id_ling = ms_lingkungan.id_ling; > group BY tr_warga.id_ling INTO CURSOR &lfCursor2 > ---------------------------------------------------------- > > PESAN ERROR YANG MUNCUL: SQL:GROUP BY clause is missing or invalid. > ---------------------------------------------------------- > Jika "group by' dihilangkan reportnya bisa tampil tapi akan terjadi > pengulangan record yang ditampilan dengan 'id_ling' yang sama. > Untuk itu saya mohon saran dan usul dari teman-teman sekalian > mengenai solusi utk masalah saya diatas. > Thanks utk bantuannya.. > > -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
