)
t

(employee name, date in time,date out time(

I want to know whoes absent in that month.

table1 ( employee name,datein,dateout)
table 2(employee name,title)
---------------------------------
I tries all these not work???

SELECT [Employee Name], [title]
FROM [table2]
WHERE ([Date in time] Is Null) And ([Date out time] Is Null);


also

SELECT Table2.*,
(select top 1 [date] from table1) AS [Date]

FROM Table2 LEFT JOIN Table1 ON Table2.[employee name] = Table1.[employee name]
WHERE Table1.[employee name] Is Null;

---------------
should I create 3 table and put that spesific month on it