SELECT COUNT(A.KDAGAMA) AS JML_PENGIKUT,
B.KDAGAMA, B.NAMA_AGAMA FROM PEGAWAI_TBL A RIGHT OUTER JOIN AGAMA_TBL B ON A.KDAGAMA=B.KDAGAMA GROUP BY B.KDAGAMA, B.NAMA_AGAMA Dan hasilnya sbb: Salam Hangat dan Jabat Erat Murid Belajar Access EdyWiyono _____ From: [email protected] [mailto:[email protected]] On Behalf Of Muhammad Sent: Sunday, June 06, 2010 13:57 To: [email protected] Subject: [belajar-access] menampilkan data yang kosong di report dear para suhu acces, di report sy ingin menampilkan data pegawai berdasarkan agama, karena di dbnya tidak ada pegawai yg beragama budha, maka yg tampil hanya agama lainnya selain budha, gimana caranya agar agama budha jg tampil direport walaupun tidak ada peg yg beragama budha (datanya kosong) salam hangat muhammada rifansyah No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.829 / Virus Database: 271.1.1/2920 - Release Date: 06/06/10 01:25:00
<<image001.gif>>
