I have thoese information
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;
---------------note
should I create 3 table and put that spesific month on it
for example
table 3(date) which will contain all date for march 1/1/2007-30/1/2007
