Untitled

	SELECT dokter.nm_dokter,pasien.nm_pasien,databarang.nama_brng,detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.biaya_obat, 
	                          SUM(detail_pemberian_obat.jml) AS jml,
	                          (SUM(detail_pemberian_obat.total)- SUM(detail_pemberian_obat.embalase+detail_pemberian_obat.tuslah)) AS total
	                          FROM dokter, pasien, detail_pemberian_obat, databarang, reg_periksa
	                          WHERE detail_pemberian_obat.`status`='Ralan' 
	                         
									  AND detail_pemberian_obat.kode_brng=databarang.kode_brng 
									  AND reg_periksa.no_rkm_medis=pasien.no_rkm_medis 
									  AND reg_periksa.kd_dokter=dokter.kd_dokter 
									  AND reg_periksa.no_rawat=detail_pemberian_obat.no_rawat
	                          GROUP BY detail_pemberian_obat.tgl_perawatan,reg_periksa.kd_dokter,databarang.nama_brng;