Postingan lainnya
WHERE BETWEEN SQL
mohon bantuannya, hasil query ini hanya tampil data yang tgl_pulang 1-9 sedangkan tgl_pulang tgl 10 tidak tampil, yang salah bagian mana ya?
SELECT
t.id,
ps.no_reg,
ps.nama,
kx.tgl,
kx.tgl_pulang,
t.tgl,
kso.nama AS penjamin,
kso.id,
tin.nama AS tindakan,
t.biaya,
p.nama AS dokter_op,
k.nama AS kelas
FROM
tindakan t
INNER JOIN pelayanan pl
ON pl.id = t.pelayanan_id
INNER JOIN kunjungan kx
ON kx.`id` = pl.`kunjungan_id`
INNER JOIN m_kso kso
ON kso.`id` = pl.`kso_id`
INNER JOIN tindakan_kelas tk
ON tk.id = t.ms_tindakan_kelas_id
INNER JOIN kelas k
ON tk.ms_kelas_id = k.id
INNER JOIN mt_tindakan tin
ON tin.id = tk.ms_tindakan_id
INNER JOIN pasien ps
ON ps.id = pl.pasien_id
LEFT JOIN pegawai p
ON p.id = t.user_id
WHERE kx.pulang = 1
AND kx.tgl_pulang BETWEEN '2022-01-01'
AND '2022-01-10'
AND tin.id = '21'
AND pl.unit_id = '103'
ORDER BY ps.no_reg ;
2 Jawaban:
<div>Pertama, pastikan dulu datanya memang ada dari tanggal 1-10 dengan kriteria yang ditentukan. Kenapa bisa tidak muncul sampai tanggal 10, mungkin bisa saja memang data nya ga sampai tanggal 10. Tapi jika sudah dipastikan datanya ada sampai dengan tanggal 10, cek lagi kriteria "tin.id" = 21 sama pl.unit_id = 103, apakah memang datanya ada, jika memang ada datanya, memang kemungkinan quernya ada yg salah.<br>Coba query between-nya diapit oleh tanda kurung seperti ini :</div><pre>SELECT
t.id,
ps.no_reg,
ps.nama,
kx.tgl,
kx.tgl_pulang,
t.tgl,
kso.nama AS penjamin,
kso.id,
tin.nama AS tindakan,
t.biaya,
p.nama AS dokter_op,
k.nama AS kelas
FROM
tindakan t
INNER JOIN pelayanan pl
ON pl.id = t.pelayanan_id
INNER JOIN kunjungan kx
ON kx.id = pl.kunjungan_id
INNER JOIN m_kso kso
ON kso.id = pl.kso_id
INNER JOIN tindakan_kelas tk
ON tk.id = t.ms_tindakan_kelas_id
INNER JOIN kelas k
ON tk.ms_kelas_id = k.id
INNER JOIN mt_tindakan tin
ON tin.id = tk.ms_tindakan_id
INNER JOIN pasien ps
ON ps.id = pl.pasien_id
LEFT JOIN pegawai p
ON p.id = t.user_id
WHERE kx.pulang = 1
AND (kx.tgl_pulang BETWEEN '2022-01-01'
AND '2022-01-10')
AND tin.id = '21'
AND pl.unit_id = '103'
ORDER BY ps.no_reg ;</pre><div><br>Semoga berhasil.</div>
Tanggapan
data tgl 10 ada... saya coba, hasilnya tetap sama, tidak tampil
<div>became a searcher,wanting to discover who i was and what made me precise. my view of myself turned into changing. i desired a stable base to start from. i commenced to resist3 stress to behave in ways that i didn’t like any greater,and i used to be delighted by who i in reality become. i got here to feel a good deal extra sure that no one can ever take my region.<br><a href="https://www.vipcontentshop.com/seo">SEO</a></div>
