Query Menampilan Unit Kerja yang Pegawainya Cuti

Untuk menampilkan Unit Kerja yang Pegawainya cuti kategori 7

SELECT tbl_unit.nm_unit  FROM tbl_unit  JOIN users ON tbl_unit.id = users.id_unit  JOIN tbl_absen ON users.id = tbl_absen.id_user WHERE tbl_absen.id_ket_in = '7' AND tbl_absen.tgl_in BETWEEN '2024-04-01' AND '2024-04-30';

SELECT      users.name, tbl_unit.nm_unit  FROM      tbl_unit  JOIN      users ON tbl_unit.id = users.id_unit  JOIN      tbl_absen ON users.id = tbl_absen.id_user  WHERE      tbl_absen.id_ket_in = '7' AND tbl_absen.tgl_in BETWEEN '2024-04-01' AND '2024-04-30';

Cek Pegawai Status Cuti

SELECT 
    users.name, 
    tbl_unit.nm_unit, 
    tbl_absen.tgl_in  
FROM 
    tbl_unit  tbl_absen
JOIN 
    users ON tbl_unit.idtbl_absen.id_user = users.id_unit  id
JOIN 
    tbl_absentbl_unit ON users.idid_unit = tbl_absen.id_user  tbl_unit.id
WHERE 
    tbl_absen.id_user = '3577'475' 
    AND tbl_absen.id_ket_in = '7' 1'
    AND tbl_absen.tgl_in BETWEEN '2024-06-01'03' AND '2024-06-30';