SQL select where

[RosieGp]

I have the following query:

Select [ID],[EmployeeNum],[EmployeeName],[DateStarted], [DateCompleted]
From [EmployeeLog] EL
where exists (select 1
from [EmployeeAddress] EA
where EA.JobStatus = 'Y'
and EA.ID = EL.ID
and EA.EmployeeNum = EL.EmployeeNum)

I want to add 1 more conditions to this...
and [DateCompleted] = NULL; [DateCompleted] (datetime) only exists in [EmployeeLog] Table...

I tried the following:

Select [ID],[EmployeeNum],[EmployeeName],[DateStarted], [DateCompleted]
From [EmployeeLog] EL
where exists (select 1
from [EmployeeAddress] EA
where EA.JobStatus = 'Y'
and EA.ID = EL.ID
and EA.EmployeeNum = EL.EmployeeNum
and EL.DateCompleted = NULL)

It did not work...
Please reply... Any help is appreciated

 

[RosieGp]

sorry, I saw what i had wrong...
so sorry guys...

Select [ID],[EmployeeNum],[EmployeeName],[DateStarted], [DateCompleted]
From [EmployeeLog] EL
where exists (select 1
from [EmployeeAddress] EA
where EA.JobStatus = 'Y'
and EA.ID = EL.ID
and EA.EmployeeNum = EL.EmployeeNum
and EL.DateCompleted IS NULL)