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/