I need to have a view of all the people who haven't log their time in the report. Basically, I am looking for null values and I have used the join properly but I am not able to figure it out.
SELECT
users.login,
t1.time,
t1.b2
FROM users
LEFT JOIN( SELECT
users.id as id,
users.login as name,
time_entries.hours as time,
time_entries.spent_on as b2
FROM users
LEFT JOIN time_entries ON users.id = time_entries.user_id
AND (time_entries.spent_on between '2021/07/19' and '2021/07/20'
OR time_entries.spent_on is null)
) AS t1
WHERE users.id = t1.id