mohon bantuannyasaya ingin menampilkan data hanya...

	Abdi Purnama Nugraha 2:28am Jul 3 mohon bantuannya saya ingin menampilkan data hanya bulan yang dipilih saja query yg saya gunakan adalah : SELECT penyidik1.nama, SUM(IF(MONTH(tahap1.t1x)=1,1,0)) AS JANUARI, SUM(IF(MONTH(tahap1.t1x)=2,1,0)) AS FEBRUARI, SUM(IF(MONTH(tahap1.t1x)=3,1,0)) AS MARET, SUM(IF(MONTH(tahap1.t1x)=4,1,0)) AS APRIL, SUM(IF(MONTH(tahap1.t1x)=5,1,0)) AS MEI, SUM(IF(MONTH(tahap1.t1x)=6,1,0)) AS JUNI, SUM(IF(MONTH(tahap1.t1x)=7,1,0)) AS JULI, SUM(IF(MONTH(tahap1.t1x)=8,1,0)) AS AGUSTUS, SUM(IF(MONTH(tahap1.t1x)=9,1,0)) AS SEPTEMBER, SUM(IF(MONTH(tahap1.t1x)=10,1,0)) AS OKTOBER, SUM(IF(MONTH(tahap1.t1x)=11,1,0)) AS NOVEMBER, SUM(IF(MONTH(tahap1.t1x)=12,1,0)) AS DESEMBER, COUNT(*) as TOTAL FROM(db_spdp.penyidik penyidik1 INNER JOIN db_spdp.spdpnya spdpnya1 ON penyidik1.id=spdpnya1.penyidik) INNER JOIN db_spdp.tahap tahap1 ON spdpnya1.no_spdp=tahap1.no_spdp WHERE (YEAR(tahap1.t1x) = '2013') and (MONTH(tahap1.t1x) between '4' and '7' ) and tahap1.t1x <> 'NULL' GROUP BY penyidik1.nama masalahnya semua bulan ditampilin...saya bingung bikin query utk if nya...agar yg ditampilin tu cuma bulan yang ada di between aja... mohon bantuannya ya masta-masta (y)
	Abdi Purnama Nugraha 2:29am Jul 3 ane pake DBMS MySQL

Abdi Purnama Nugraha 03 Jul, 2013

-
Source: http://www.facebook.com/groups/35688476100/?id=10151732455936101
--
Manage subscription | Powered by rssforward.com