I want to display my data without duplication in any of the columns,

I use distinct or group by tetep it doesn't work

**my sql :**

```sql
SELECT DISTINCT rl.NIK,date(rl.enroll),LEFT(TIME(rl.enroll),8) AS time
FROM RTattandenceLog rl, mstEmp e
WHERE DATE(rl.enroll)=CURDATE()-1 AND e.idDept=3 AND e.NIK=rl.NIK

```

**this is resultc:**   

[![enter image description here](https://i.stack.imgur.com/7aGo2.png)](https://i.stack.imgur.com/7aGo2.png)

**the lines I crossed should not be displayed**