SELECT vs.flag_absen,vs.id,vs.TglKunjungan,DATE_FORMAT(vs.WaktuUpload,"%H:%i") Jam,vs.WaktuUpload,vs.WaktuKunjungan,vs.Posisi, sl.IDSales,sl.KodeSales,sl.NamaSales,sl.AlamatSales,cs.IDCust,cs.KodeCust,cs.NamaCust,cs.NamaToko,cs.AlamatCust FROM tr_visit vs LEFT JOIN tm_sales sl ON sl.IDSales = vs.IDSales LEFT JOIN tm_customer cs ON cs.IDCust=vs.IDCustomer WHERE TRUE
and vs.TglKunjungan >= "2020-01-01"
and vs.TglKunjungan <= "2020-01-31"
and sl.KodeSales = "kris"
GROUP BY flag_absen