You don't need the sub select

select a.operatorID, a.FirstName, a.LastName, a.Phone1
from Operator a, OperatorJobs b
where (a.OperatorID = b.OperatorID) and (b,EndDate is not  null)
order by a.OperatorID
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to