QUERY REKAP RAJAL

SELECT
    rajal.No_Register,
    regis.No_RM,
    regis.Nama_Pasien,
    regis.AlamatPasien as Alamat,
    regis.NoPeserta as "No BPJS",
    pasien.NoKtp as "No NIK",
    regis.Umur,
    regis.JenisKel as "Jenis Kelamin",
    antrian.is_pasien_baru as "Pasien Baru",
    rajal.NamaAsuransi as "Nama Asuransi",
    poli.NamaPoli as "Nama Poli",
    rajal.Tgl as Tanggal,
    rajal.DiagnosaPrimer as "Kode Diagnosa",
    rajal.NamaDiagnosaPrimer as "Nama Diagnosa"

FROM tr_rawatjalantindakan rajal
JOIN tr_registrasi regis
    ON regis.No_Register = rajal.No_Register
JOIN tm_customer pasien
    ON regis.No_RM = pasien.KodeCust
LEFT JOIN natusi_apm.antrian antrian
    ON pasien.KodeCust = antrian.no_rm
JOIN tm_poli poli
    ON regis.Kode_Poli1 = poli.KodePoli
-- WHERE rajal.Tgl BETWEEN '2024-07-01' AND '2024-07-31'
-- WHERE rajal.Tgl BETWEEN '2024-08-01' AND '2024-08-30'
WHERE rajal.Tgl BETWEEN '2024-09-01' AND '2024-09-30'
GROUP BY rajal.No_Register