Hi Mayank,
This might help you
Table1 - Timesheet
Columns - employeeid, startdate, enddate
Table2 - employee
Columns - employeeid,employeename
this is a query you can perform - query format [SQL SERVER]
SELECT DISTINCT e.employeeid,e.name
FROM employee e
left outer join timesheet t on t.employeeid = e.employeeid
where t.startdate != N'2012-01-01' OR t.enddate != N'2012-01-01'
In the above statement in WHERE clause change OR -> AND according to your requirement.