QUERY POLI KUNJUNGAN DAN RM OUT

SELECT
  *
FROM
(SELECT

            UNITSUB.KD_INST AS KD_UNIT,
            UNITSUB.KET AS KET,
            --PASIEN.NAMA AS NAMA,
            --PASIEN.NO_PASIEN AS NO_PASIEN,
            --DAFTAR.NO_DAFTAR AS NO_DAFTAR
            COUNT(DAFTAR.NO_DAFTAR) AS JUMLAH



         FROM RAWATPOLI
         INNER JOIN DAFTAR ON RAWATPOLI.NO_PASIEN=DAFTAR.NO_PASIEN AND RAWATPOLI.NO_DAFTAR=DAFTAR.NO_DAFTAR
         INNER JOIN UNITSUB ON RAWATPOLI.KD_INST = UNITSUB.KD_INST AND RAWATPOLI.KD_INST = UNITSUB.KD_SUBINST
         INNER JOIN PASIEN ON RAWATPOLI.NO_PASIEN=PASIEN.NO_PASIEN
         --LEFT JOIN RMOut ON RMOut.No_Pasien = PASIEN.NO_PASIEN
         WHERE
            YEAR(RAWATPOLI.TANGGAL)='2019' AND
            MONTH(RAWATPOLI.TANGGAL)='10' AND
            DAY(RAWATPOLI.TANGGAL)='17' AND
            RAWATPOLI.KD_INSTASAL IS NULL AND
            RAWATPOLI.KD_SUBINSTASAL IS NULL

            --ORDER BY RAWATPOLI.TANGGAL ASC
            GROUP BY UNITSUB.KD_INST, UNITSUB.KET
            ) AS BITXH
FULL OUTER JOIN

 (SELECT RMOut.Kd_SubInst AS UNITT, COUNT(*) AS DISTRIBUSI FROM RMOut WHERE CONVERT(VARCHAR(10), RMOut.Tanggal, 21) LIKE '2019-10-17%' GROUP BY RMOut.Kd_SubInst) AS BITCH

            ON BITXH.KD_UNIT = BITCH.UNITT