SELECT ws.*,e.first_name,e.last_name FROM #Request.prefix_db_lookup#.Employee e LEFT OUTER JOIN #Request.prefix_db_agency#.Employee_Workschedule ws on e.Employee_ID = ws.Employee_ID WHERE e.Employee_ID = #session.cs.employeeid# AND e.Agency_ID = #Session.AgencyID# AND e.status = 'active' AND ws.status = 1 order by schedulestart asc