Untitled
unknown
plain_text
a year ago
911 B
5
Indexable
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;
Editor is loading...
Leave a Comment