Viewing post 1 (of 1 total)
select e.employeeID,e.firstName,e.lastName,m.MeetingID
from employees e
left outer join meetingAttendance m
on e.employeeID=m.employeeID
where meetingDate between @StartDate and @EndDate
and MeetingID=@MeetingID
and MeetingAttendanceID is null
October 28, 2005 at 8:49 am
#600934