Query All Employees Who Have Not Logged In for the Day

[jrsarrat]

Greetings!

I have produced a query that shows only the names of employees who have not logged in. But, I want the query to also only give me the employees who have not logged in for the current date = Date().

How do I incorporate that into this query I have already produced :

SELECT *
FROM Emp_tbl AS e
WHERE NOT EXISTS
(select null from tblEmpLogin t where t.pf_id = e.pf_id);

The date field 'DTE' is in table tblLogInOut.

Thank you for your help!

 

[Joe4]

Your query references table "Emp_tbl" and "tblEmpLogin", but the you say that the date field is in the "tblLogInOut" table.

I think you need to tell us the structure and relationships of all three of these tables (how they relate to each other).
And perhaps post some sample data. I am most interested as to what the data looks like in the table that shows whether or not they have logged in.