Join two tables

[QUES]

Hi I write a query based on access database and this program is written is asp.net. In the database, we have tables: One is employee and the other is TimeCheck. I want to select those who are in the Employee table but not in the timeCheck table, so I write my query like this:

strSQL = "SELECT Employee.Name, Timecheck.ServerDate FROM Employee  INNER JOIN TimeCheck ON Employee.idEmployee = timeCheck.idEmployee Where ServerDate = '" & SdateB & "' and Employee.Name NOT in timeCheck"

(NOTE** sdateB is a variable which I defined before and it equals to the text of the textbox entered.)

Error: Syntax error in JOIN operation
Would anyone give me any advice? Thanks in advance!

 

[jrbarnett]

SELECT employee.name, timecheck.serverdate
FROM employee LEFT OUTER JOIN timecheck on employee.idEmployee = timecheck.idEmployee
WHERE serverdate = sDateB AND
timecheck.idEmployee IS NULL

John